Alright, so in cell A2-100 is the time stamp, Cell H2-100 could either have a value or blank. Cell i2-100 is a cool down timer (WHICH IM MAKING THIS POST ABOUT). I have no clue how to write the formula so I’m asking you guys.
So if Cells in the “H” column are blank, I want the cells in the “i” column in the same row to be red.
If theres a value in the H column, I want it to be green in the “i” column.
This is where the time stamp comes into play. I want the cells that are red in the “i” column as a result of there being a blank in the corresponding H column to turn green 3 days after the time stamp recorded the submission.
Anybody know the formula?