Hi all
I'm not sure whether this is a conditional formatting or VBA issue, so I apologise if I have submitted this on the wrong forum.
I am attempting to create a RAG sheet which will track the creation of manuals.
I work for a company that has to create 2 x manuals for every job we do to provide information to our clients before and after the the job.
The RAG sheet is being put in place to monitor the time it takes for each person to create and supply each manual for each job.
I currently have a sheet with the current date (using TODAY()) in column A1, the Start dates in column F, Due dates column G.
The sheet should show the job as green if TODAY() is 1 day or more before the due date
The sheet should show the job as amber if TODAY() is the same as the due date
The sheet should show the job as red if TODAY() is after the due date
So for example, if a Due Date is 03/11/18 and the Start Date is 15/10/418 the job should be green until 02/11/18, amber on 03/11/18, and red on 04/11/18 onward
I also need to be able to find a way to 'close' a job on the sheet, so once a manual has been created it won't just keep showing as red. I want to be able to input this myself.
Currently I've been trying conditional formatting but with no luck, as I can't even seem to get the sheet to turn red/green/blue with the simplest formula, so I imagine I am writing it wrong, but excel is not showing that there are any errors and I can't find any information for what I want specifically online
Green: =IF(Today()=G2=1, Green)
Amber: =IF(Today()=G2, Amber)
Red: =IF(Today()>G2, Red)
Thank you for your help in advance
Bookmarks