K
kvedogg
I'd like to format cells in Excel for 10 different text conditions. At the
simple end I can format a cell by saying Cell Value is Equal To ="John". I
can do that for 3 different names. I can even trick the system by using Cell
Value is Between ="John" and ="Mike" and have 6 conditions. How I enter
information that would for example turn the cell blue for a John, Mike or
Sara entry and red for a Jane, Bob, Sally or Paul entry?
Any help is appreciated.
simple end I can format a cell by saying Cell Value is Equal To ="John". I
can do that for 3 different names. I can even trick the system by using Cell
Value is Between ="John" and ="Mike" and have 6 conditions. How I enter
information that would for example turn the cell blue for a John, Mike or
Sara entry and red for a Jane, Bob, Sally or Paul entry?
Any help is appreciated.