Conditional Formatting Help needed.

[losnfx]

Hi Everyone I been going crazy trying to figure out a conditional formatting formula. What im trying to achieve is if a specific range contains the number 0 highlight the cell next to it. ill break it down further below:

So if A1 contains the number 0,
highlight B1 which contains the number 32,
but if C1 contains another number greater then 0 dont highlight c1.

A1 = 0, B1 = 32, c1 = 24, d1 = 0, e1 = 0, f1 = 32

I think I explained it right but not sure. help
Thanks

 

[Jonmo1]

Welcome to the board...

Not sure I follow completely, but this may be a start.

Highlight B1:F1
Formula is
=AND(A1=0,B1>0)


Hope that helps