Tricky Conditional Formatting in Excel 2007

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I am looking for a conditional formatting formula that will highlight cell R6 if C6 is 5241 and cell R6 is greater than 30:00:00 I have to do this for several other numbers that will be in C6.
Is there a limit to the number of rules for a cell?

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
About first part of your question, would C6 contain a range of numbers or like odd/even number etc or they would be just random numbers with no patterrn ?

For the second part of question, yes there is a limit of three conditions. How ever there is a workaround by use of macro. See Aquarelle answer on this thread
https://ccm.net/forum/affich-21716-conditional-formatting-more-than-3-in-excel