Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Colour Using if Statement
Hello, I just posted this question but it wasnt quite correct, here is the
new question. I have the following calculation in a cell: =IF(qryData!CI37 = 0, TREND(D28:D34,$B$28:$B$34,$B$35,1), qryData!CI37) 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. qryData!CI37 is not equal to 0. I have tried the conditional formatting but it doesnt seem to work Many thanks, Martin |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Colour Using if Statement
Thers' no need to post it again you have an answer in your first thread
"Martin" wrote: Hello, I just posted this question but it wasnt quite correct, here is the new question. I have the following calculation in a cell: =IF(qryData!CI37 = 0, TREND(D28:D34,$B$28:$B$34,$B$35,1), qryData!CI37) 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. qryData!CI37 is not equal to 0. I have tried the conditional formatting but it doesnt seem to work Many thanks, Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colour using If statement | Excel Worksheet Functions | |||
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 |