How do I tell Excel to highlight the entire row when data from two columns
does not match exactly, i.e. g3 should be exactly the same as h3 but if not,
highlight the entire 3rd row?

Thank you.

Select the range to highlight (I'm using A3:X999)
With row 3 containing the activecell:

Format|Conditional formatting
formula is:
=$H3<$G3
and give it a nice format.

The $'s will mean that columns H and G will always be used to determine the
formatting for that row. With no $ in front of the 3's, excel will adjust them
for each row in the selected range.

Coco wrote:

How do I tell Excel to highlight the entire row when data from two columns
does not match exactly, i.e. g3 should be exactly the same as h3 but if not,
highlight the entire 3rd row?

Thank you.

--

Dave Peterson

Select all of row 3 or just the portion to highlight.

FormatCFFormula is: =$H3<$G3

Choose a pattern from Format and OK your way out.

Note the $ signs to lock the columns but not the rows in case you want to copy
that format to other rows.


Gord

On Sat, 24 Feb 2007 10:38:05 -0800, Coco wrote:

How do I tell Excel to highlight the entire row when data from two columns
does not match exactly, i.e. g3 should be exactly the same as h3 but if not,
highlight the entire 3rd row?

Thank you.

=NOT(EXACT($A1,$B1))


"Coco" wrote:

How do I tell Excel to highlight the entire row when data from two columns
does not match exactly, i.e. g3 should be exactly the same as h3 but if not,
highlight the entire 3rd row?

Thank you.

Thank you for your help.
I'm doing something wrong.
Highlighted range.
Selected Conditional Formatting button.
Highlight cell rules/more rules
Format only cells that contain
cell value/not equal to/put in your formula
selected yellow fill/ok
but yellow filled in all my selected area except a column that is blank.
Thank you.

"Dave Peterson" wrote:

Select the range to highlight (I'm using A3:X999)
With row 3 containing the activecell:

Format|Conditional formatting
formula is:
=$H3<$G3
and give it a nice format.

The $'s will mean that columns H and G will always be used to determine the
formatting for that row. With no $ in front of the 3's, excel will adjust them
for each row in the selected range.

Coco wrote:

How do I tell Excel to highlight the entire row when data from two columns
does not match exactly, i.e. g3 should be exactly the same as h3 but if not,
highlight the entire 3rd row?

Thank you.

--

Dave Peterson

You don't want "Cell value is"
You need "Formula is"
--
David Biddulph

"Coco" wrote in message
...
Thank you for your help.
I'm doing something wrong.
Highlighted range.
Selected Conditional Formatting button.
Highlight cell rules/more rules
Format only cells that contain
cell value/not equal to/put in your formula
selected yellow fill/ok
but yellow filled in all my selected area except a column that is blank.
Thank you.

"Dave Peterson" wrote:

Select the range to highlight (I'm using A3:X999)
With row 3 containing the activecell:

Format|Conditional formatting
formula is:
=$H3<$G3
and give it a nice format.

The $'s will mean that columns H and G will always be used to determine
the
formatting for that row. With no $ in front of the 3's, excel will
adjust them
for each row in the selected range.

Coco wrote:

How do I tell Excel to highlight the entire row when data from two
columns
does not match exactly, i.e. g3 should be exactly the same as h3 but if
not,
highlight the entire 3rd row?

Thank you.

--

Dave Peterson

I got it!
Thank you very much.
Thank you all so much for your time and information!


"David Biddulph" wrote:

You don't want "Cell value is"
You need "Formula is"
--
David Biddulph

"Coco" wrote in message
...
Thank you for your help.
I'm doing something wrong.
Highlighted range.
Selected Conditional Formatting button.
Highlight cell rules/more rules
Format only cells that contain
cell value/not equal to/put in your formula
selected yellow fill/ok
but yellow filled in all my selected area except a column that is blank.
Thank you.

"Dave Peterson" wrote:

Select the range to highlight (I'm using A3:X999)
With row 3 containing the activecell:

Format|Conditional formatting
formula is:
=$H3<$G3
and give it a nice format.

The $'s will mean that columns H and G will always be used to determine
the
formatting for that row. With no $ in front of the 3's, excel will
adjust them
for each row in the selected range.

Coco wrote:

How do I tell Excel to highlight the entire row when data from two
columns
does not match exactly, i.e. g3 should be exactly the same as h3 but if
not,
highlight the entire 3rd row?

Thank you.

--

Dave Peterson