specific value returns to colour cells

[Aberdham]

Hi Guys,

I Need some help with regard to when certain cells have value and return to colour-shaped Status:

I have 2 different workbooks:

one indicating:

Jan

<tbody>
</tbody>

Serial number <tbody> </tbody>	Process fee	Registration fee	process cost	Registration cost	accrual process cost	accrual Registration cost
136552 <tbody> </tbody>	56554	58412	45258	45245
168953 <tbody> </tbody>	59596				58555
123658 <tbody> </tbody>	88859		59658
562563 <tbody> </tbody>	55569	57854		35698	45858
246558 <tbody> </tbody>	85895	45895	59598			36562
546454 <tbody> </tbody>
456132 <tbody> </tbody>			56555
545651C <tbody> </tbody>					56985
589858
698959
595895

<tbody>
</tbody>

and the other one indicating: Description: - all cells process and Registration fees; process cost (or accrual process cost) Registration cost (or accrual) have value Returns to on Progress. - all cells have no values Returns to (a green Label on 04) - process and Registration cost(including accrual process and Registration) have value; no values in process or Registration fee ( a red Label on O5) - values in process fee and process cost or accrual process cost (a yellow Label on 06) - when Serial number =589858, 698959 etc Returns to an orange Label on 07 <tbody> </tbody> <tbody> </tbody> Jan Feb March April Serial number 136552 168953 123658 562563 246558 546454 456132 545651C 589858 698959 595895 <tbody> </tbody>

<tbody>
</tbody>

could any of you come up with a formula or a VBA code to help me do the trick?

any help would be greatly appreciated !

Thanks

 

[alansidman]

I dont understand what you mean by "returns an orange label on 07," etc. What are your referring to? What is an 04 or 05, etc. Perhaps you could show an example of what you mean in your illustration for each of your issues.

 

[Aberdham]

I dont understand what you mean by "returns an orange label on 07," etc. What are your referring to? What is an 04 or 05, etc. Perhaps you could show an example of what you mean in your illustration for each of your issues.

Hi Alan,

Thanks for your quick Response !
O4;O5;O7 refers to the column and row.
I Need to have the respective value filled in the workbook indicating the Status; different Status versus different colour
with exception of the first description Returns to text as "on Progress"

hope to hear from you soon
Thank you

 

[Aberdham]

I hope that's a bit more clear now guys...

I did try to Format it as a table but it doesn't seem to work.

please help me out...

thanks...

 

[Aberdham]

would multiple if and lookup works in this case?

 

[Aberdham]

any idea anyone?

 

[alansidman]

I still cannot correlate your example shown to your explanation. Perhaps a sample showing what you are doing with a before and after example.

 

[Aberdham]

Serial number	Process fee	Registration fee	process cost	Registration cost	accrual process cost	accrual Registration cost			Column1
136552	56554	58412	45258	45245					Description:
168953	59596				58555				- all cells process and Registration fees; process cost (or accrual process cost) Registration cost (or accrual) have value Returns to on Progress.
123658	88859		59658						- all cells have no values Returns to (a green Label on 04)
562563	55569	57854		35698	45858				- process and Registration cost(including accrual process and Registration) have value; no values in process or Registration fee ( a red Label on O5)
246558	85895	45895	59598			36562			- values in process fee and process cost or accrual process cost (a yellow Label on 06)
546454									- when Serial number =589858, 698959 etc Returns to an orange Label on 07
456132			56555	45456
545651C				56985	56985
589858
698959
595895
Column1	Column2	Column3	Column4	Column5
	Jan	Feb	March	April
Serial number
136552	on progress
168953
123658
562563	on progress
246558	on progress
546454
456132
545651C
589858
698959
595895									Perhaps this might help... But i can't seem to get the cells filled with Color here

<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col span="2"><col></colgroup>