Forum Discussion
Solved
Conditional formatting traffic light system with blanks
Hi all, I have been asked to create something and i'm really struggling to create the formula so i'm hoping someone here could help me out! I currently have a formula in column J - =IF(E6-D6<...
Thanks. See the attached sample workbook. I created a formula in column J that returns 1, 2, 3 or 4 and used those values in the traffic light conditional formatting rule.
And what if E6 is blank and D6 is more than 6 days before today's date?
Thanks. See the attached sample workbook. I created a formula in column J that returns 1, 2, 3 or 4 and used those values in the traffic light conditional formatting rule.
Hans, you sir are a hero! Your formula worked perfectly for me. Thank you very much for your time and effort! Have a great day!
