Hi i am trying to write a formula that will help me build a compliance report on my excel document. I have already set my document up with conditional formatting to show that when a date of completed training is due to expire it turns red.
What i want to do now is a compliance report beside it which will have the headings of each year and underneath that i want to it to either have a 0, 1 or 2 depending on the colour code on the data. Does this sound like something that can be done. I can send a copy of what my data looks like if needs be!
What i want to do now is a compliance report beside it which will have the headings of each year and underneath that i want to it to either have a 0, 1 or 2 depending on the colour code on the data. Does this sound like something that can be done. I can send a copy of what my data looks like if needs be!
