| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Colour using If statement
Hello,
I have the following calculation in a cell: =IF(C28+C41 = 0, TREND(C9:C15,A9:A15,A16,1),C28+C41) This is to use the trend function if the cell value is 0, this works fine. What I would like to do however is to colour the font in red if the trend function is being used but leave as black if there is actual data there i.e. C28+C41 is not equal to 0. I would really appreciate knowing how to do this. Many thanks, Martin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can colour of cell shading be fixed to one colour | Excel Discussion (Misc queries) | |||
| how to create a if statement, if true turn colour | Excel Worksheet Functions | |||
| How do I save new colour schemes for graphs in the colour template | Charts and Charting in Excel | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| Text in Blue colour, but print in black colour | Excel Worksheet Functions | |||
Threaded Mode
