I need to make cells change colour on certain days of the week but cannot figure out the formula.
I am trying to work on the basis 1 is Sunday, 2 is Monday etc. I only need to use Monday and Friday in my scenario.
So, in laymans terms I need to say, if today = Monday put 2 in cell C70 if its Friday put 6 otherwise put 0
I will then use the 2,6,0 to build my conditional formatting.
Hope this makes sense.