ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   colour change as a result of a figure (https://www.excelbanter.com/excel-discussion-misc-queries/184367-colour-change-result-figure.html)

Jo

colour change as a result of a figure
 
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.

yshridhar

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.



All times are GMT +1. The time now is 10:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com