Forum Discussion
Formulas and Functions
Please Help - I'm no Excel expert!!
I am trying to improve a log of audit actions, more specifically their timescales for completion.
This is the formula I currently have in Cell M2:
=I...
Hi Ismael,
Your formula seems to work the same as my current. Which is perfect apart from what I want to add, as follows:
If the date in Column L (Completion) Lapse over Column K (Timescale) It should go Red.
Your formula seems to work the same as my current. Which is perfect apart from what I want to add, as follows:
If the date in Column L (Completion) Lapse over Column K (Timescale) It should go Red.
It does. If L is past K it resutls in R.