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:
<tbody>
</tbody>
<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
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>
<tbody> </tbody> | Process fee | Registration fee | process cost | Registration cost | accrual process cost | accrual Registration cost | |
<tbody> </tbody> | 56554 | 58412 | 45258 | 45245 | |||
<tbody> </tbody> | 59596 | 58555 | |||||
<tbody> </tbody> | 88859 | 59658 | |||||
<tbody> </tbody> | 55569 | 57854 | 35698 | 45858 | |||
<tbody> </tbody> | 85895 | 45895 | 59598 | 36562 | |||
<tbody> </tbody> | |||||||
<tbody> </tbody> | 56555 | ||||||
<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>
<tbody> </tbody> |
<tbody>
</tbody>
any help would be greatly appreciated !
Thanks