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

It could be as simple as just affixing the $ sign appropriately within the CF
formula
Eg: using something like this: =$A1="x"
as the CF formula when applying it with the entire sheet selected (with A1
active) will conditionally format entire rows where col A contains "x"
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Namvar" wrote:
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?

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

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

Thanks it did work.

"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

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Namvar" wrote in message
...
Thanks it did work.

"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