I have a spreadsheet, that shows different delivery dates inside one column. I would love to use conditional formatting to highlight dates that are close to today's date. Is that possible with conditional formatting?
The data would look like this:
D / E344103 LT 05.04.22 / E350521 LT 25.03.22 / E316524 LT 31.05.22 / E316601 LT 15.04.22 / E318314 LT 24.03.22
I would love to have everything farther out than 4 Days coloured in red, and as we're approaching closer to today's date move to orange and then finally green.
Any help that gets me in the right direction would be greatly appreciated.
I have no idea how to approach this. I have very limited experience with conditional formatting.
CodePudding user response:
Make a separate column with just the dates
The next step would be to find the difference in dates. There is a help forum on this here.
The corresponding VBA code is very basic:
ActiveCell.FormulaR1C1 = "Today is 23/03/2022."
ActiveCell.Characters(Start:=10, Length:=10).Font.Color = RGB(255, 0, 0)