Highlite Col A if value Col B

April 10, 2011 at 10:46:32
Specs: Windows 7
I want to use conditional formating to Highlite a value a value in Column A if it si greater than the value in the same row in Coumn B

See More: Highlite Col A if value Col B

Report •


#1
April 10, 2011 at 10:56:26
Try this for 2003:

1st – Select the cell

On the Menu Bar:

2nd - Format
3rd - Conditional Formatting
4th – Change “Cell Value is” to “Formula Is”
5th – Enter the formula:

=IF(A1>B1,TRUE,FALSE)

Sub Menu Format :
6th - Patterns
7th - Choose a pretty color.
8th - Press OK

See how that works.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question