![]() |
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. |
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