daveryandewey
New member
- Joined
- Feb 21, 2013
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hi I have created my conditions and am now trying to copy them to the next rows.
The sheet will always be added to in the future so I do not want to use absulote refferences. I can go through the rows I have now but this will not assist me with future row insertions.
All my other formulas seem to work fine:
=AND($G39<>"", TODAY()-$G39>25) - Turn row amber if date exceeds 25 days from current date
=AND($G39<>"", TODAY()-$G39>30) - Turn row red if date exceeds 30 days from current date
=$L39="In-Progress" - If marked as In-Porgress - do not format the row
=$L39="Completed" - If marked as Completed- do not format the row
=ISBLANK($G39)
I can copy the format to each row and then currently have to amend the applies to range. However when I try to amend the "Applies to" field for each condition (So that the refference is not absulote) it will not remove the $ refference. I have tried using F4, removing all formatting and starting again. I have also tried various ways to create - i.e highlighting the row and then using the CFR manager.
Please help as I am going mad.....
The sheet will always be added to in the future so I do not want to use absulote refferences. I can go through the rows I have now but this will not assist me with future row insertions.
All my other formulas seem to work fine:
=AND($G39<>"", TODAY()-$G39>25) - Turn row amber if date exceeds 25 days from current date
=AND($G39<>"", TODAY()-$G39>30) - Turn row red if date exceeds 30 days from current date
=$L39="In-Progress" - If marked as In-Porgress - do not format the row
=$L39="Completed" - If marked as Completed- do not format the row
=ISBLANK($G39)
I can copy the format to each row and then currently have to amend the applies to range. However when I try to amend the "Applies to" field for each condition (So that the refference is not absulote) it will not remove the $ refference. I have tried using F4, removing all formatting and starting again. I have also tried various ways to create - i.e highlighting the row and then using the CFR manager.
Please help as I am going mad.....