I am looking for help with a Conditional Formatting formula. What I am trying to do is identify which employees are able to achieve a weekly result that is less than 10% or the previous month results. In the attached doc I am looking for all the employees whose December 7th results (column H) are a minimum 10% less than Nov results (Column E). When they are I will have the Column H cell for that employee change a different fill color. Then I will duplicate for the subsequent weeks.
Bookmarks