muhleebbin
Active Member
- Joined
- Sep 30, 2017
- Messages
- 252
- Office Version
- 365
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
- MacOS
- Mobile
- Web
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!
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!