Link to home
Start Free TrialLog in
Avatar of agwalsh
agwalsh

asked on

Set up conditional formatting so that it goes orange within two cells of a zero entry

How can I apply conditional formatting to a sheet so that within 2 cells of it showing zero it goes orange. See desired effect attached sheet.
Thank you :-)
EE-CF-within-distance-of-blank-cell.xlsx
ASKER CERTIFIED SOLUTION
Avatar of NBVC
NBVC
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The above solves it if you mean within two to the RIGHT.  If you mean within two cells left or right, you need a couple more "OR" items :-)

Great answer from NBVC though!
Avatar of agwalsh
agwalsh

ASKER

@nbvc. That works well although I just had to tweak the formula to read as follows..(allowing for the different cells I put it into...). Thank you :-)
=AND($F4<>0,OR(G$4=0,H$4=0))
Avatar of agwalsh

ASKER

Had to tweak it a tiny bit but worked beautifully :-)