Conditional Formatting 2 Columns

October 26, 2010 at 16:08:46
Specs: Windows XP
I am trying to format 2 columns:

1 6 68
2 2 52
3 8 10
4 4 61
5 9 100
6 7 40
7 5 25

Above is a simplified example of what I am trying to do. I want to be able to highlight the row where Column "A" is greater than 5 and Column "B" is greater than 50, if both conditions are not satisfied then do nothing. I have been messing with it for a while and can get it to do a single row but now multiple rows.

I have tried to use the Conditional Formatting using a formula:
=AND($A$1:$A$7>5,$B$1:$B$7>50) with my selection as: $A$1:$B$7

What am I doing wrong or am I going about this all wrong?

See More: Conditional Formatting 2 Columns

Report •

October 26, 2010 at 17:30:29
Conditional formatting doesn't work over a range (e.g. A1:A7), it works on one cell at a time (A1). However, it can be applied to an entire range in one move:

Select A1:B7 and use this formula for CF. Note the placement of the $.


When you want to Conditionally Format a range of cells, you Select the entire range, but you use a formula that only refers to the first cell. Excel knows to apply the CF to the entire range, changing the address as appropriate.

Now, in this case, we need to use $ on the columns otherwise Column B would end up being CF'd with:


Report •

October 27, 2010 at 05:43:45
Thank you so much, I really appreciate your help!

Report •

Related Solutions

Ask Question