View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
yshridhar yshridhar is offline
external usenet poster
 
Posts: 229
Default colour change as a result of a figure

Format|conditional format|condition 1 cellvalue = 0;click font tab select
colour-white|condition 2 cellvalue0;click select font colour-black
Best wishes
Sreedhar

"jo" wrote:

Hi. I really hope somebody can help me. I need to know how to create the
following result please:
if the value of the sum in a cell equals zero then make the font colour
white, but if the value of the sum is greater than zero then make the font
colour black.
Thanks.