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!

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

"Kevin" wrote:

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!

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.




"Barb Reinhardt" wrote:

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

"Kevin" wrote:

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!

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

"Kevin" wrote:

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.




"Barb Reinhardt" wrote:

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

"Kevin" wrote:

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!

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

On Mon, 18 Jun 2007 18:46:01 -0700, Kevin
wrote:

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.




"Barb Reinhardt" wrote:

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

"Kevin" wrote:

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!