Condition formatting based on other cells values

M

Marco

Hi. How do I format a cell with condition formatting based on other ceels?

I have cell A1 and I want that this cell appears in red whenever B1 as bad
written.

How??

Regards,
Marco
 
P

Pete_UK

I think this is what you mean - select A1 and Format | Conditional
Formatting, then select Formula Is rather than Cell Contents from the
drop-down in the first panel, and in the formula panel enter:

=B1="Bad"

Click on the Format button, then select the Patterns tab (for
background colour) and select your colour. Click OK twice to exit
these pop-ups.

You can copy the conditional formatting to other cells if required by
using the Format Painter.

Hope this helps.

Pete
 
A

aidan.heritage

I think this is what you mean - select A1 and Format | Conditional
Formatting, then select Formula Is rather than Cell Contents from the
drop-down in the first panel, and in the formula panel enter:

=B1="Bad"

Click on the Format button, then select the Patterns tab (for
background colour) and select your colour. Click OK twice to exit
these pop-ups.

You can copy the conditional formatting to other cells if required by
using the Format Painter.

Hope this helps.

Pete




- Show quoted text -
Click to expand...

NOTE that you PROBABLY need $B1 rather than just B1 if you are going
to be using format painter
 
P

Pete_UK

Good point, Aidan, but I assumed that he would be copying it down the
column or to another column where the adjacent cell could contain
"Bad".

Pete
 
Top