View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sam Sam is offline
external usenet poster
 
Posts: 699
Default If statement and cell format

I have a the following formula in A1 cell =if(Logic_test, A2,A3).
In A2 I have "increase" in red font and in A3 I have "Decrease" in blue
font. But when the value printed in A1 it is black no matter what. How can I
make the format (mainly color of the font) of A1 to be same as A2 or A3?

<redincrease</red