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
Thank you :-)
EE-CF-within-distance-of-blank-cell.xlsx
Microsoft Excel
Last Comment
agwalsh
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
=AND($F4<>0,OR(G$4=0,H$4=0
ASKER
Had to tweak it a tiny bit but worked beautifully :-)
Great answer from NBVC though!