Condition formatting based on other cells values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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
 
Back
Top