Hi,
I'm hoping the forum can help.

I have an excel sheet where i need to highlight a cell with a date in it, that is 3 days past today's date, when the "staff name" cell is white (no fill).

When the "staff name" cell is highlighted green (which turns green when i enter a hyperlink), i need the date cell to go white (no fill). I have tried different formatting and tried some VBA coding, but i cant get it to do what i need. The significance of the "green" cell is when the staff member submits their paperwork it is hyperlinked and the cell goes green.

So, for example, cell B9 will go "red" if paperwork is outstanding after 3 days. However, when they submit paperwork, it is hyperlinked and their name will go green (i have formatting for this already). This is when i need the date cell (B9) to go back to no fill.

I hope this makes sense
thanks