Hi,
I've just created a project log spreadsheet for tracking actions, risks & issues etc.
The last time I did this I was using Excel 2003 and I added a rule to change the text once the actions/risk/issue was closed.
Basically, I've said =$G$3="Closed" then format the text to be italic and grey out the entire row.
I've recreated this in the new 2007 spreadsheet, but when I try to copy the rule down to the next row, it keeps the =$G$3 format rather than automatically editing it to that of the next row (ie: =$G$4).
I thought that the way to resolve this was to remove the $, but this doesn't appear to work.
I have dozens of actions/risks/issues to create, so I can't afford to edit them per individual cell.
Can anyone help me to copy them across correctly?
Regards,
Steve
Bookmarks