Conditional Formatting, multiple blank or zero

How would a conditional formatting statement be written to cover multiple conditions in a cell, such as a blank cell or a "0" (zero) in a cell. Column of cells actually.

Thanks for any assistance

dgd1212Asked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
In conditional formatting you don't really need an IF function, just a statement that returns TRUE or FALSE, so if you wanted to format column A if it contains "x" or "y" then this would suffice

=OR(A1="x",A1="y")

For your specific example, if the blanks are truly blank then Excel actually treats those as zeroes so in that case you only need a single condition

=A1=0

That will format any zero that actually contains a zero or is truly blank

If you want to apply to a whole column you just select the column first and then use the formula applicable to row 1, so the above formulas would work to format the whole of column A

regards, barry
0
 
roger_karamConnect With a Mentor Commented:
You can use an iff statement in the conditional formatting then copy it down. Example:

In cell A1, use the following formula for conditional formatting = if(OR(A1=0;A1="');1;0) , than drag the format down to the other cells

hope that helps
-RK
0
 
shahzadbuxCommented:
you may need to adjust roger_karam's formula to change the ; to , depending on your regional settings...
0
 
roger_karamCommented:
Barry's answer is the way to go. Used to the IF statement because i remember having trouble with older versions of excel without it.
0
 
dgd1212Author Commented:
Thanks guys. Also didn't realize that a "blank cell" = 0
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.