Hello all.
I am looking for a formula for the 3-color scale CF, going from white yellow and than red based off future dates. The white color means nothing in this cause but when the cells date is 6 months (180 days) from the date in needs to be yellow and then red when 3 months (90) days from that day turns red. I got as far as using a countif and now functions but it has not worked out. I appreciate your assistance, thank you
I am looking for a formula for the 3-color scale CF, going from white yellow and than red based off future dates. The white color means nothing in this cause but when the cells date is 6 months (180 days) from the date in needs to be yellow and then red when 3 months (90) days from that day turns red. I got as far as using a countif and now functions but it has not worked out. I appreciate your assistance, thank you