Thread: Change text colour
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] Shaijuzacharia@gmail.com is offline
external usenet poster
  
Posts: 12
Default 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)
Reply With QuoteReply With Quote