Another option is to use CF with a text string which wil never be used

Formatconditional FormattingCondition1

'Cell Value Is' 'not equal to' in the third box type "~~~~" and select a
fill color

If this post helps click Yes
---------------
Jacob Skaria


"Mainer" wrote:

i have a form that needs input in some cells and then needs to be printed. I
would like to color those cells so the user knows which cells they can change
but i dont want the colors to show up when i print the form