dgd1212
asked on
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
Thanks for any assistance
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you may need to adjust roger_karam's formula to change the ; to , depending on your regional settings...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
Thanks guys. Also didn't realize that a "blank cell" = 0