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

#### gizzylover

##### Board Regular
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?

### Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
While in C5, go to Format|Conditional Formatting. Select Format Is from Drop Down and enter:

=C5>40 click Format and choose Pattern> Yellow

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

=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.

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.

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!!

Replies
2
Views
498
Replies
2
Views
315
Replies
3
Views
139
Replies
3
Views
201
Replies
16
Views
525

1,203,620
Messages
6,056,327
Members
444,861
Latest member
B4you_Andrea

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back