Hi all
I'm creating a workbook to be used for monitoring test scripts.
My issue is that I need to fill one group of merged cells (is six cells merged which is a script status indicator and should display the word PASS or FAIL) with a colour reflecting the status.
Column E is the Pass/Fail indicator for each test step and can only contain 'Pass' or 'Fail' and has a fixed number of rows (ie the number of test steps)
– If any cell in E contains 'Fail' I would like my merged cell to turn red and say 'Fail'
- If all cells in the rows used in E have 'Pass' I would like it to be green and say 'Pass'
- if all cells in E below the limit of the completable number of rows in E have 'Pass' I'd like it to stay white and say 'Incomplete'
Any help with this would be most appreciated
Thanks
Will
Bookmarks