Select entire Row 3
From the main menu select Format.Conditional Formatting
Select : Formula Is (from the dropdown list)
Criteria: =$M$3>1
Click the [Format...] button and select a green fill color
Click the [OK] buttons when done.
Yes, it worked beautifully! Thank you!
--
Thank you,
(e-mail address removed)
Ron Coderre said:
Select entire Row 3
From the main menu select Format.Conditional Formatting
Select : Formula Is (from the dropdown list)
Criteria: =$M$3>1
Click the [Format...] button and select a green fill color
Click the [OK] buttons when done.
Does that help?
•••••••••••
Regards,
Ron
SCrowley said:
Let's say $M3 contains a formula J3/I3 which returns a percentage. I want the
row to color if the resulting percentage is over 100%.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
