Lawrence429
New Member
Hi all --
I am trying to develop a chart to follow process on various projects. I would like to put a % complete in column K and have columns A - J either red for % incomplete or green for % completed. So if the project is 75% complete, the first 7 columns would be green and the remaining 3 would be red, if only 10% is complete, column A would be green and the rest red. See the attached example (without any coding).
thanks for your help
Lawrence
PS I am not that good with VBA so if we could stick with formulas that would be great, if VBA is necessary please be detailed.
I am trying to develop a chart to follow process on various projects. I would like to put a % complete in column K and have columns A - J either red for % incomplete or green for % completed. So if the project is 75% complete, the first 7 columns would be green and the remaining 3 would be red, if only 10% is complete, column A would be green and the rest red. See the attached example (without any coding).
thanks for your help
Lawrence
PS I am not that good with VBA so if we could stick with formulas that would be great, if VBA is necessary please be detailed.