Formula for completed work

[Vishaal]

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

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

 

[Anonymous1378]

Something like this I guess:

Book78
	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	Done	Done	Done	Done	In Process
13	Dan	Done	Done	Done	In Process
14	Ronshi	Done	Done	In Process
15	Pome	Done	Done	Done	Done	Done	In Process
Sheet1

Cell Formulas
Range	Formula
B12:G15	B12	=IF(COUNTA($B$11:B$11)<=COUNTIF($B3:$S3,"Done"),"Done",IF(COUNTA($B$11:B$11)=COUNTIF($B3:$S3,"Done")+1,"In Process",""))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B12:G15	Cell Value	="Done"	text	NO

 

[Vishaal]

Thanks for the help, Anonymous1378​

its working and my problem solved