Coloring Text

C

Color Text

Hi, I am trying to color just text (no formulas) within a cell down a column.

Example:
If text in column B is Q1 or Jan, Feb, March change to organe; Q2 or April,
May, June change to yellow; Q3 etc...

Can this be done? I do not know how to use VBA so I am trying to do this
without.
LMagg
 
E

Eric

You can do it with format-conditional formatting, but you're limited to
specifying a different format for up to three different conditions, so you
can't do it based on the month field. You can extend this to four options
(perfect for your four quarters) by simply defining "Q1" values as one color,
"Q2" as another, "Q3" as another...then letting a fourth color serve as the
default if it's not subjected to the Q1, Q2 or Q3 parameters.
 
Top