How do you change font color based on the value input? 1 = <red>.

I am trying to set a column with the following funtionality:

1 = <red>1
2 = <yellow>2
3 = <blue>3
or
High = <red> High
Med = <yellow> Med
Low = <Blue> LOW

Mojeta,

Try Format - Conditional Formatting. Use "Cell value is." Use "Equal to"
and 1, click Format, and choose your color. Then click Add, and do the next
color.
--
Earl Kiosterud
www.smokeylake.com

"mojeta" <mojeta@discussions.microsoft.com> wrote in message
news:4B63DE6E-9870-42F3-9C52-33CAFDBDC1AE@microsoft.com...
>I am trying to set a column with the following funtionality:
>
> 1 = <red>1
> 2 = <yellow>2
> 3 = <blue>3
> or
> High = <red> High
> Med = <yellow> Med
> Low = <Blue> LOW
>