I have a question that someone may be able to help me with.
If I have a column called Finish Date.
On line 5 - I enter a date that my customer wants project to be finished
On line 4 - I have a automatic date that is from a predecesor based on finish date so that it populates automatically depending on the tasks completed above it.
- My question is how do I add a conditional format to line 4 (turn it Red and Bold say) based on the auto date being within 5 days of the date that has been entered on line 5?
I hope that someone can give me a suggestion as it would be great!
Thanks 