Forum Discussion
Help with conditional formatting
Hello, i have a spreadsheet at work that tracks job statuses and i would like to have it auto fill certain colors depending on how long the project has been open, amber for a few days, orange for a w...
Hi Paul,
In general you need only four rules, one for each colour. For green rule formula is like
=<complete cell> = "complete"
for red like
=((TODAY() - <receive date>)>7)*(<complete cell> <> "complete")
on so on. Only correctly use absolute and relative references in formulas.