Hi,
You can use conditional formatting to do this.
For the first condition, set the cell equal to "Continue with booking" then
set the font colour you want.
Do this for the each of the other conditions.
If you have XL2007, you can do all four conditions in this way. If not, you
can only set 3 conditions, and you'll have to use the default font to colour
the 4th condition.

Regards - Dave.

" wrote:

Hi All

I am slightly stuck...i have my IF formula below but i need each IF
outcome to be a different font colour i.e.Continue booking needs to
show up in red, Find Venue needs to show up in Blue etc.


=IF(AND(U13=6,D13<""),"Continue with
booking",IF(AND(U13=5,D13=""),"Find Venue",
IF(AND(U13<=5,D13<""),"More
delegates",IF(AND(U13<=5,D13=""),"Cancellation candidate"))))


Is there a simple formula i can add to my formula above??!! I have red
somewhere about using [Red] or [Blue] but i cannot seem to make this
work.

Any ideas would be greatly appreciated!!!