Hello all. I've tried to solve this by searching the forum and just can't get this right. I've attached a sample file for clarity. I would like to have 4 cells in a row react to a 5th cell in the same row. This is a job tracking file and need delivery dates watched and shaded black to orange to red as the dates get closer. I'm using conditional formatting but can't get all 3 colors to change. I'm sure I'm missing something simple but my head hurts from banging it on the wall. I need help.
Thanks in advance.
Bookmarks