I am trying to format 2 columns: A B

1 6 68

2 2 52

3 8 10

4 4 61

5 9 100

6 7 40

7 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?

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 appliedto 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)

Thank you so much, I really appreciate your help!

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History