Conditional Formatting (highlighting a column)

[muhleebbin]

I have data in cells B8:AA17 where data is in rows 8:16 and a sum function in row 17. I'm trying to have a conditional format where if row 7 (month) is less or equal to the actual month and if row 17 is 0 that it highlights the column between rows 8:17.

I'm using this formula =IF(AND(B7<=$AC$1,B17=0),TRUE,FALSE) for the conditional format rule for area B8:AA17 but it only highlights row 8. Can someone please help me fix my stupidity?

Thanks in advance!

 

[Joe4]

If you want all the cells to look at rows 7 and 17, you need to lock the row numbers down in your formula by placing a "$" in front of them, i.e.
=AND(B$7<=$AC$1,B$17=0)

Also, there is no need to use an IF formula. The AND function already returns a boolean value (True/False), so you don't need to tell it to do so explicitly.
So writing it like I have shown above should be sufficient.

 

[muhleebbin]

If you want all the cells to look at rows 7 and 17, you need to lock the row numbers down in your formula by placing a "$" in front of them, i.e.
=AND(B$7<=$AC$1,B$17=0)

Also, there is no need to use an IF formula. The AND function already returns a boolean value (True/False), so you don't need to tell it to do so explicitly.
So writing it like I have shown above should be sufficient.

Thank you for saving me from myself! Totally worked!

 

[Joe4]

You are welcome.