I have a column that has cells in it that I need to automatically highlight red given the following criteria:

--A date in the same row (different column) is before the current date.

For example: If the date in column B is 8/7/19 and today is 8/8/19, I need the cell in that row in column A to highlight red.

Cam anyone please help? - I know how to do this in VBA; however, my supervisor does not want to have to push a button to update the sheet.