conditional formatting
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
"T. Valko" wrote:
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
|