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")

--
Biff
Microsoft Excel MVP


"Namvar" wrote in message
...
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