Suggestions for cell update reminders
 

Hello -
I have a report which I update monthly - it requires a huge amount of
formulas and formatting etc - all of which need to updated monthly.

I am trying to think of the best way to create a 'map' or list of updates
which need to be made so that I can verify against it every month.

I was going to just make a simple list - IE:
Cell A1 - change X
Cell D24 - update x

I thought I might see if anyone had a better idea?!!?

Thanks

Suggestions for cell update reminders
 

I don't know if this would help, particularly as you mentioned formatting.

If you have a cell (eg A1) to act as a switch, you can use conditional
formatting in the cells you need to check to highlight the cells.

eg in one of the cells you need to check set conditional formatting as
Formulas is and set the formula as

=$A$1<""

Set a format to highlight the cell (font or background colour, underline,
bold, italic, border colour etc).

--
Ian
--
"Elgee" wrote in message
...
Hello -
I have a report which I update monthly - it requires a huge amount of
formulas and formatting etc - all of which need to updated monthly.

I am trying to think of the best way to create a 'map' or list of updates
which need to be made so that I can verify against it every month.

I was going to just make a simple list - IE:
Cell A1 - change X
Cell D24 - update x

I thought I might see if anyone had a better idea?!!?

Thanks