I am trying to format a cell based on another cell's value but I already have a formula in place to count the age of an entry in days - ie., =DAYS(TODAY(),C2). When the age is >20 days it turns the cell red. Now I have another cell on the same row that when an action has been taken and the value is changed to an X and that cell turns green, I need my original cell that has the age formula in it to turn green as well.
