Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change text colour
I have given the below formula and this gives #NA in columns with no
values. I want to change the font colour to white if the cell has #NA. =IF(ISERROR(100*(AF5-AH5)/AH5),NA(),100*(AF5-AH5)/AH5) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change text colour if range of values all zero | Excel Worksheet Functions | |||
Change text colour according to number | Excel Worksheet Functions | |||
change text colour | New Users to Excel | |||
Quick Text colour change? | Excel Discussion (Misc queries) | |||
Change Colour OF Text??? | Excel Discussion (Misc queries) |