conditional formatting

[Namvar]

Hi
I have got a large amount data in table and I am using conditional format to
highlight some of the cell swith unique data.

The issue is that I would like to highlight the whole row with that data on
it.

Is there any way I can use any function in x-cell or do I have to use macro?

Help needed.

Thanks

 

[T. Valko]

See if this is does what you want...

...........A..........B..........C
1........Y..........N.........Y

You want to highlight A1:C1 if any cell in the range contains "N".

Select the range A1:C1
In Conditional Formatting, use the Formula Is option
Use this formula:

=COUNTIF($A1:$C1,"N")

 

[Namvar]

I am using 2007 version and it des not provide me formula option as you said .

I sthere other way to highlight the entir row when the condition foamtting
highlite the cell

Thanks

 

[Namvar]

Thanks it did work.

See if this is does what you want...

...........A..........B..........C
1........Y..........N.........Y

You want to highlight A1:C1 if any cell in the range contains "N".

Select the range A1:C1
In Conditional Formatting, use the Formula Is option
Use this formula:

=COUNTIF($A1:$C1,"N")

 

[T. Valko]

You're welcome. Thanks for the feedback!