conditional formatting 2 rules

[hopr37]

Trying to use conditional formatting with 2 sets of rules.
Each time I try different rules ( using AND) it never works

All I'm trying to accomplish is:
If C4 has no value and D4 has a value then fill C4 with a color.
and down the line
If C5 has no value and D5 has a value then fill C5 with a color

But only If D4 has a value. If both cells C4 and C5 are blank then leave them blank
etc...

 

[Joe4]

Try this Conditional Formatting rule:

=AND(C4="",D4<>"")

 

[hopr37]

That does indeed work.
Is there a way to have the same outcome if the value in D4 is greater than "0"?
the way I have my sheet set up is that there may be a value in D4 ranging from "0" to whatever.
I have to blank out D4 to get C4 to remove the color.
In other words. As long as D4 has any value in it and C4 has no value then it will always fill C4.
something like "if D4>0 and C4= nothing then.....

is that possible?

 

[Joe4]

something like "if D4>0 and C4= nothing then.....

You have already practically written it yourself, especially seeing how I did the previous one. Just change out the conditions are you see fit.

I did:
D4<>""
which basically says D4 is not empty (contains something, can be a number, letter or space)

If you want to include any number greater than zero, just change it to:
D4>0

If you want to include zero as the number it may contain, then change it to:
D4>=0

 

[hopr37]

that's what I originally did but it kept giving me an error. I'll try again.

huh. It works now. I must of had a character missing or something. Thanks for the help