Highlighting Minimum value
 

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?

Highlighting Minimum value
 

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.

"Lgirl" wrote:

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?

Highlighting Minimum value
 

IT WORKED!
Thank you so much!

"akphidelt" wrote:

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.

"Lgirl" wrote:

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?