Hello,
Apologies if the title is too vague I am having trouble describing what it is that I am trying to do correctly and may need to adjust the title with some assistance.
I am using a spreadsheet to assist with the flow of numerous projects taking place at my workplace. The projects have different stages and requirements along the way which need to be completed at certain times to ensure the smooth sailing of the project. This particular section of the sheet is used to identify if a project is late with a certain requirement and if this is the case to place a RED TEXT in a cell next to the project listing.
Rules:
When a project has reached 'Business Case' Phase then it is a requirement for certain documents to be completed. If the project moves along to the next phase without these documents being completed then the project will receive a red alert.
I am trying to create a formula which will read the cell that displays the stage of the project along with whether the documents have been completed and then rate the project with a specific word ie: Red, Green, Amber in the cell next to these inputs.
A1=Business Case and B1=empty then C1="AMBER, you must complete documentation before moving on"
A1=Design and B1=empty then C1="RED, you are late with documentation"
A1=Design and B1="Complete" then C1="GREEN, you are up to date with documentation"
I am able to get a formula that will read both cells and then provide an outcome in the third cell but am unsure how I can add the second rule and so on into this
This is what I have so far...
I think I need to include OR function in here but am unsure how.Please Login or Register to view this content.
Came up with something along the lines of:
Does not work. . .Please Login or Register to view this content.
I have attached the proposed rules in further detail to give further understanding of what it is that I need. I am not sure whether it is possible to format cell with this many rules.
Any assistance with this would be greatly appreciated.
Best Regards,conditional formatting register.xlsx
Bookmarks