Therefore I expected to see some dates in your data. Is this sample file really representative for your case? Made an educated guess and added a date header above the values.I want the cells to change colour as dates pass as a visual to being paid without input
Newbie here and the other one didn't look like it posted when I did it.
You said
Therefore I expected to see some dates in your data. Is this sample file really representative for your case? Made an educated guess and added a date header above the values.
Thanks for the file but then the change will only occur after the month is over not by specific date.That is representative of my file so why
DAY(TODAY()) >20 works should allow the other to work because it's a format not a value