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
Bookmarks