I am trying to use an if function to color code cells. I am ok with using Conditional formating also, but I can not find the correct formula/function to make it work how I want.
I am trying to color code a cell if the value of another cell is the word "Complete".
Cell B15 is a date.
Cell D15 is a word (either complete, in progress, or not complete)
If D15 is the word "Complete" then I would like Cell B15 to turn Green. Either using conditional formating or a function formula.