Highlighting Minimum value

  • Thread starter Thread starter Lgirl
  • Start date Start date
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?
 
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.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditonal formatting problem! 1
Excel Highlighting duplicates 0
error in highlighting duplicate values in excel 1
how do you have 2 criterias be picked up in a lookup? 2
Highlight MAX Cell Greater Than Zero 4
Conditional Formatting by percent range 2
Conditional Formatting - Reference to multiple column 3
Conditional Formatting - Excel 2003 2

Back
Top