OfficeUser
Well-known Member
- Joined
- Feb 4, 2010
- Messages
- 542
- Office Version
- 365
- 2016
- Platform
- Windows
Hello All, its been awhile, hoping everyone is well. I have cell (R3) containing the following formula: =IF($E3="","",$E3-($F3+$H3+$J3+$L3+$N3+$P3))
This cells are formatted for currency. What I am trying to accomplish is to highlight all cells from A3:R3 lite green when the value in R3 is $0.00. I am struggling to figure it out given the formula in R3. Any suggestion? In the meantime, I'll definitely keep trying to figure out a solution.
Thanks!!
This cells are formatted for currency. What I am trying to accomplish is to highlight all cells from A3:R3 lite green when the value in R3 is $0.00. I am struggling to figure it out given the formula in R3. Any suggestion? In the meantime, I'll definitely keep trying to figure out a solution.
Thanks!!