Patterned cells automatically if no value

Hi,

I'm really sorry for asking such a basic question - but I'm flummoxed!

I have a spreadsheet which i use to record how many hours have been spent on a certain task per week.

I fill this in from sheets that employees bring in each week. However - the sheets are not always returned!

It would be really useful if I could set excel to automatically put a pattern (ie a red block) in cells that have no value, and automatically remove it when there is a value entered.

obviously I can click on them - and do the 'properties - pattern' but when I have so many blank boxes to fill - this takes a long, long time!

Regards
Sarah Nash

Hi, Try this:-
NB:- Reds a bit Heavy!!

Please Login or Register  to view this content.

Regards Mick

Fantastic - thank you so much!