Specifying color to different text

  • Thread starter Thread starter Nick Burns
  • Start date Start date
N

Nick Burns

Hello,

Could someone please help me figure out the correct
formula to use to specify a color to different text. Say
if I enter an A in a field, I would like it to be red. If
I enter B in that same field, I would like it to be blue.
I'm pretty sure I would us an IF function but I can't seem
to format the output correctly. Any help would be
appreciated.

Thank you,
struggling support person...
 
Hi Nick

if you've got 3 or less conditions then use conditional formatting
so for your example, click on cell and choose format / conditional
formatting
choose Value Is, EQUAL, "A", click on Format button choose red font - click
Ok then click on ADD
choose Value is, EQUAL, "B", click on Format button choose blue font - click
Ok & OK

Hope this helps
Cheers
JulieD
 
Back
Top