Hi,
Below is a section of my working code.
When it runs the year is entered into cell E7
I just need to add to the existing code that when the entered year is placed in E7 it needs to be Red.
Maybe .Font.ColorIndex = 3 but where does it need to be added to the code below
Please advise thanks...