Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
HI, we have the following sheet where we want to track the status of work through conditional formatting and with text in process, kindly provide any excel formula
we have the excel 2007, 2010
sheet
result sheet with conditional formatting
Result sheet with text (work status)
Thanks
we have the excel 2007, 2010
sheet
New Microsoft Excel Worksheet - Copy.xlsx | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |||
1 | Work | Step 1 | Step 2 | Step 3 | Step 4 | Step 5 | Step 6 | ||||||||||||||
2 | Date | Status | Late | Date | Status | Late | Date | Status | Late | Date | Status | Late | Date | Status | Late | Date | Status | Late | |||
3 | John | 21/08/2012 | Done | 23/08/2012 | Done | 26/08/2012 | Done | 28/08/2012 | Done | 30/08/2012 | |||||||||||
4 | Dan | 24/08/2012 | Done | 26/08/2012 | Done | 27/08/2012 | Done | 28/08/2012 | |||||||||||||
5 | Ronshi | 24/08/2012 | Done | 26/08/2012 | Done | 27/08/2012 | |||||||||||||||
6 | Pome | 21/09/2012 | Done | 23/09/2012 | Done | 26/09/2012 | Done | 28/09/2012 | Done | 30/09/2012 | Done | 1/10/2012 | |||||||||
Sheet4 |
result sheet with conditional formatting
New Microsoft Excel Worksheet - Copy.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
10 | Status - Steps Completed | ||||||||
11 | Work | Step 1 | Step 2 | Step 3 | Step 4 | Step 5 | Step 6 | ||
12 | John | ||||||||
13 | Dan | ||||||||
14 | Ronshi | ||||||||
15 | Pome | ||||||||
Sheet4 |
Result sheet with text (work status)
New Microsoft Excel Worksheet - Copy.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
18 | Status - Steps Completed | ||||||||
19 | Work | Step 1 | Step 2 | Step 3 | Step 4 | Step 5 | Step 6 | ||
20 | John | Done | Done | Done | Done | In Process | |||
21 | Dan | Done | Done | Done | In Process | ||||
22 | Ronshi | Done | Done | In Process | |||||
23 | Pome | Done | Done | Done | Done | Done | In Process | ||
Sheet4 |
Thanks