Conditional Formatting of Cells
Posted by Don on December 02, 2000 6:04 PM
In cell A1 I have a date. I have formulas in cells A2:A12 that calculate percentages. What code can I write that will change the font of the date in cell A1 to red if any of the percentages in cells A2:A12 are greater than a specified number. Example: If any of the percentages in cells A2:A12 were greater than 50 then the date in cell A1 would turn red. I've tried several approaches but nothing worked.
Thanks in advance
Don
Posted by Celia on December 02, 2000 6:30 PM
Don
For cell A1 under Conditional Formatting use the following formula :-
=Max(A2:A12)>50%
Celia
