x3droopyx3
New Member
Hello,
I'm in need of some help. I'm in the inspection industry and need to build a chart of the inspections i'm currently doing each inspection is due every 3 years but what i like to do is use a formula that uses a color scale using red yellow and green red getting close to the 3 year expiration yellow half way and green most recent inspection. i would like for the cells to color them self daily.
I'm in need of some help. I'm in the inspection industry and need to build a chart of the inspections i'm currently doing each inspection is due every 3 years but what i like to do is use a formula that uses a color scale using red yellow and green red getting close to the 3 year expiration yellow half way and green most recent inspection. i would like for the cells to color them self daily.