Conditional Formatting

[Andrew]

Hi i have applied some conditional formating to a
selection of cells but want them to all be white until
the values are changed by the user

Any adise would be welcome

 

[David McRitchie]

Hi Andrew,
Then you want a Change Event Macro instead of C.F.
http://www.mvps.org/dmcritchie/excel/event.htm#change
--