Conditional formatting - Highlighting a row

[Guest]

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 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.

 

[Gord Dibben]

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

Format>CF>Formula 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

 

[Guest]

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

 

[Guest]

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.

 

[David Biddulph]

You don't want "Cell value is"
You need "Formula is"

 

[Guest]

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