I need a formula for conditional formatting a cell based on a percentage of another cell, This is for a project Timeline Manager chart so would like the formula to auto copy when adding new projects. C1 = blank H3 = percentage data bar 0-100% I would like: C1 to input "Not Started" if Percentage of H3 is 0% C1 to input "In Progress" if percentage of H3 is between 1-99% C1 to input "complete" if percentage of H3 is 100%
Solved by I. J. in 21 mins