Hi,
I've been grappling with this problem but can't fathom how to do it.
I am creating a table of departmental approval of Q&A's. 4 Different departments each need to approve each question. I'm trying to create a spreadsheet of their approval/non-approval.
As such, I was hoping to create a table with conditional formatting to make it easier to see which ones need acting on etc.
So I have a table with 6 columns - Question, Answer and then the 4 departmental replies.
I would like each row to be different colours based on the reply.
As they reply I shall say yes or no based on whether they give approval or not.
So - if there are outstanding replies - it should be red
If there are all the replies but some are "no"s then it should be yellow.
And if all the cells are "yes"s it should be green.
I've had a go at this for ages now with no success. Some help would be much appreciated.
Edit: More complication I'm afraid. Instead of Yes/No it's going to be Date of approval or Reasons for non-approval. Thanks.
Bookmarks