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, [email protected]
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%.
