Conditional Formatting - Compare 2 Cells, then the next 2...

[gizzylover]

Need help with multiple conditional formatting. I have a set of cells C5-AO99. I want to compare C5 with C6 - if C5 is over 40, i want it highlighted in yellow. If C6 is under 40 AND C5 is greater C6, I want it highlighted in green. If C5 is 0 and C6 is greater than 1, I want it highlighted in orange.

Then I want to repeat this check for D5 and D6, E5 and E6, and so on through AO5 and AO6 to complete the row.

The next row of comparisons would begin at C8 and C9 and repeat all of the above checks.

Next Row C11 & C12, next Row, C14 & C15, and so on through C98 and C99.

Can someone help me figure this out?

 

[NBVC]

While in C5, go to Format|Conditional Formatting. Select Format Is from Drop Down and enter:

=C5>40 click Format and choose Pattern> Yellow

Then click Add and enter:

=AND(C6<40,C5>C6)....format Green

Click Add again and enter

=AND(C5=0,C6>1)....format Orange

Then copy this cell and paste special>Format to all the first cells of each group of 2.

 

[Tazguy37]

Welcome to MrExcel Board!

Try this in Format, Conditional Formatting (with Cell C5 selected):

Condition 1:
Cell Value Is, greater than, 40 -- use yellow format
Condition 2:
Formula Is: =AND(C6<40,C5>C6) -- use green format
Condition 3:
Formula Is: =AND(C5=0,C6>1) -- use orange format

and then use the Format Painter on the formatting toolbar to copy the conditional formatting to the other cells (or you can use Paste Special).

Hope that helps! Post back if I missed anything.

 

[gizzylover]

You completely ROCK! I have been trying to figure this out for 2 hours. Am forever indebted. Okay, maybe not forever, but I send you a really big THANKS!!