colour change as a result of a figure

J

jo

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.
 
Y

yshridhar

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change background colour of a row if a particular cell has a value 1
Question about conditional formatting of zeros in Excel 0
Conditional formatting for time 1
Changing coloue cell en text colour by clicking cell 3
textBox font colour the same as cell font colour???????? 4
conditionally formatting colour of cells 2
Conditional Format - formula = 0 vs. entering zero 10
Calculations based on cell colour 6

Top