Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change text colour | Charts and Charting in Excel | |||
Change text colour according to number | Excel Worksheet Functions | |||
change text colour | New Users to Excel | |||
how to change colour of text in true or false formula | Excel Worksheet Functions | |||
Change Colour OF Text??? | Excel Discussion (Misc queries) |