Conditional Format Question

[Guest]

I just can't seem to remember how to do a format like I want.

I want highlight multiple cells in a row IF a cell = N

IE:

cell A1 is N I want to highlight cells A2-A10
if cell A1 is Y I want no highlighting.


anyone know of a quick formula for that?

thanks!

 

[Guest]

Select cells A2:A10
Format - > Conditional Format
Formula is
=A$1="N"

Set the format as desired.

What do you want if A1 <> "N" and A1 <> "Y". If you want no highlighting,
you're done.

HTH,
Barb Reinhardt

 

[Guest]

thanks.. what is odd is it does the exact opposite of what I want LOL

I changed it to =$A$1<>"N" and then it works the way I want (cells
highlighted ONLY if there is an N in cell A1.

I thank you a bunch for getting me in the right direction!

1 quick response question though, do yuo know of a way to paset that
formatting for each row? every time I use either the format painter, or
copy/paset special or whatever, it messes up the cell it is looking for.

 

[Guest]

If you are using version 2007, you could just add another string in the
'applies to' box.

 

[Gord Dibben]

You have to change the absolute reference so row 1 is not fixed.

=$A1<>"N" fixes column A and allows relative referencing for rows.


Gord Dibben MS Excel MVP