Select entire Row 3
From the main menu select Format.Conditional Formatting
Select : Formula Is (from the dropdown list)
Criteria: =$M$31
Click the [Format...] button and select a green fill color
Click the [OK] buttons when done.
Does that help?
€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron
"SCrowley" wrote:
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%.
--
Thank you,