[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 60
  • Last Modified:

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
0
agwalsh
Asked:
agwalsh
  • 2
1 Solution
 
NBVCCommented:
Select the entire range from C5:N7, then go to Home|Conditional Formatting|New Rule

Select "use a formula to determine which cells to format" and enter formula:

=AND(C5<>0,OR(E5=0,D5=0))

Then click Format and choose from Fill tab.
1
 
RayData AnalystCommented:
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!
0
 
agwalshAuthor Commented:
@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))
0
 
agwalshAuthor Commented:
Had to tweak it a tiny bit but worked beautifully :-)
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now