JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 567
- Office Version
- 365
- Platform
- Windows
I have a formula in a column =IF(OR($I81<>"",$O81<>""),"", SUM(E81:F81))
When the IF statement returns "" the cell in blank. I want to highlight the cells that are greater than zero in conditional formatting but when I set that parameter the blank cells with the formula are highlighted. How can I get conditional formatting to ignore the formula's?
Thank you
James
When the IF statement returns "" the cell in blank. I want to highlight the cells that are greater than zero in conditional formatting but when I set that parameter the blank cells with the formula are highlighted. How can I get conditional formatting to ignore the formula's?
Thank you
James