Conditionally formatted data: compare each cell to the adjacent cell.

Question

Can I enter a conditional formatting rule once that will apply to each cell in the selection, comparing a cell to its adjacent cell:

Is A1 > B1

Is A2 > B2

Is A3 > B3

etc.

With one rule for multiple cells?

Answer 1

Can I enter a conditional formatting rule once that will apply to each cell in the selection, comparing a cell to its adjacent cell:

Is A1 > B1

Is A2 > B2

Is A3 > B3

etc.

With one rule for multiple cells?

Hi Ray

Please, try the following steps

1. Select the whole range from cell A1 as in the picture
2. Go to Conditional Formatting >> New Rule...

3. Use a formula to determine...
4. Enter the formula =$A1>$B1
5. Select the formatting of your choice
6. Press OK

RESULTS

I hope this helps you and gives a solution to your problem

Do let me know if you need more help

Regards

Jeovany

Answer 2

Hi,

Click on cell A1 and go to Home > Conditional Formatting > New rule > Use a formula to determine which cells to format. In the box there, type A1>B1. Click on Format and select the desired formatting. Copy cell A1, select A2:A10 and right click > Paste special > Formats > OK.

Hope this helps.