Forum Discussion
Conditional Formatting
Hi all I’m trying to get cell D in the attached photo to change either red if cell C is before today’s date, Green if cell C is after today’s date and Clear if no data is in Cell C How do I also...
Thank you so much, its done the trick.
Sorry about the picture I do know about snipping tool I just couldn't use it to be able to do this, as I couldn't get to this site on my work computer
The purpose of it is to show when we will need to contact people to do training
Last refresher training wont be the future, that will be the past and next refresher will be a future date dependent on when the last training was conducted
Sorry about the picture I do know about snipping tool I just couldn't use it to be able to do this, as I couldn't get to this site on my work computer
The purpose of it is to show when we will need to contact people to do training
Last refresher training wont be the future, that will be the past and next refresher will be a future date dependent on when the last training was conducted
IngeborgHawighorst Sorry looks like something funny is going on.
anything before the current day needs to be Red and anything that is in the future needs to be Green in the Next refresher training cell
Also if you were to input the current day into the last refresher training it fills in the next refresher with a clear box, how could I go about having that as green aswell?
