QA: 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

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.

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.

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