# Conditional Formatting 2 Columns

October 26, 2010 at 16:08:46
Specs: Windows XP
 I am trying to format 2 columns: A B1 6 682 2 523 8 104 4 615 9 1006 7 407 5 25Above 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\$7What am I doing wrong or am I going about this all wrong?

See More: Conditional Formatting 2 Columns

#1
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 \$. =AND(\$A1>5,\$B1>50)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:=AND(B1>5,C1>50)

Report •

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

Report •

Related Solutions