Hey all right basically (hopefully basic) what I am looking to do is my boss has created a spread sheet of when all the people in the office go out of dxate for certain things some last 3 years some last more or less. He would like the box to do the normal amber and then red when over the alloted time but also to get the box to go red if there is no date entered. I know how to do the red if out of date for each box and the red of nothing entered but that would need to be put in each box so I am wondering if anyone would have a nice macro or an idea to aply it to the whole spreadsheet?
Thanks in advance