Conditional Formatting


I've had some difficulty doing this today, though I think it's easy to do.

I have a meta data sheet with a column that sums tasks in a particular status (Status (RYBG)) and another column that sums task state (Task State (In Progress, Complete, Not Started). Task State is determined by a formula depending upon the % Complete.

If the numbers in these columns don't match, I know there's a missing formula. For easy QC, if these two columns don't match - I would like to have the Status column turn orange. Can I do this with conditional formatting?

Best Answer