Home » questions » Using "1" and a blank space......How do I use an "If" statement in excel 2003 to hide coloured areas

Using "1" and a blank space......How do I use an "If" statement in excel 2003 to hide coloured areas

2006-08-09 10:24:01, Category: Programming & Design
Basically we are using conditional formatting to bring coloured cells to other sheets. What we are trying to do is create an "If" statement that will keep a cell free of color until a number is entered into that specific cell.

Answers

  1. PoliPino

    On 2006-08-09 10:41:47


    So you're trying to accomplish this without using conditional formatting? I didn't think there was a way to enter equations in a cell to affect a cell's format, only its value. Conditional formatting is the only way to accomplish that in excel as far as I knew.
  2. qwertykph

    On 2006-08-11 12:20:26


    You don't need an IF statement. Use conditional formatting. Choose "If Cell Value" "Greater Than" and then put "0" in second box. Then choose you color scheme! Regards, QwertyKPH @ Yahoo