Highlighting Minimum value

L

Lgirl

I have two colums of values. I need the value in column A highlighted
whenever it is greater than the corresponding value in column B.
I'm not having a problem doing that for a particular cell through
conditional formatting, but I can't seem to get ti to appy to the whole
column.

Help?
 
A

akphidelt

Highlight column A, and select Conditional Formatting

Change cell value is to Formula Is

and then type in the formula

=$A1>$B1

Make sure to include the $ signs.
 
L

Lgirl

IT WORKED!
Thank you so much!

akphidelt said:
Highlight column A, and select Conditional Formatting

Change cell value is to Formula Is

and then type in the formula

=$A1>$B1

Make sure to include the $ signs.
Click to expand...
 
Top