G
Guest
I have a small spreadsheet and am using conditional formatting. The
individual cells have several possible arguments, and I am coloring the
background differently depending on the information. Some cells have a blank
in front of the data, and some don't. Is there a way to use boolean logic to
create, in effect, more than the three conditions? I have Cell Value Equal To
="pnd" as one of the conditions, and want to be able to say Cell Value Equal
To OR(="pnd",=" pnd") or however the syntax should be for the boolean logic.
In English I want it to be if cell value is equal to "pnd" or " pnd", then
the condition is true and the cell changes color. I know, I know, I can
always use an edit check to ensure I don't get blanks in front of some of the
data, but......can't I combine boolean logic and conditional formatting?
individual cells have several possible arguments, and I am coloring the
background differently depending on the information. Some cells have a blank
in front of the data, and some don't. Is there a way to use boolean logic to
create, in effect, more than the three conditions? I have Cell Value Equal To
="pnd" as one of the conditions, and want to be able to say Cell Value Equal
To OR(="pnd",=" pnd") or however the syntax should be for the boolean logic.
In English I want it to be if cell value is equal to "pnd" or " pnd", then
the condition is true and the cell changes color. I know, I know, I can
always use an edit check to ensure I don't get blanks in front of some of the
data, but......can't I combine boolean logic and conditional formatting?