Tricky Conditional Formatting in Excel 2007

Closed
Don - Jun 29, 2010 at 07:28 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 29, 2010 at 12:12 PM
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?

Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 29, 2010 at 12:12 PM
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
0