specific value returns to colour cells

Aberdham

Board Regular
Joined
Mar 8, 2018
Messages
140
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
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
6,066
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
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

Board Regular
Joined
Mar 8, 2018
Messages
140
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

Board Regular
Joined
Mar 8, 2018
Messages
140
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

Board Regular
Joined
Mar 8, 2018
Messages
140

ADVERTISEMENT

would multiple if and lookup works in this case?
 

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
6,066
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
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

Board Regular
Joined
Mar 8, 2018
Messages
140
Serial numberProcess feeRegistration feeprocess costRegistration costaccrual process costaccrual Registration costColumn1
13655256554584124525845245 Description:
16895359596 58555 - all cells process and Registration fees; process cost (or accrual process cost) Registration cost (or accrual) have value Returns to on Progress.
12365888859 59658 - all cells have no values Returns to (a green Label on 04)
5625635556957854 3569845858 - process and Registration cost(including accrual process and Registration) have value; no values in process or Registration fee ( a red Label on O5)
246558858954589559598 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 5655545456
545651C 5698556985
589858
698959
595895
Column1Column2Column3Column4Column5
JanFebMarchApril
Serial number
136552on progress
168953
123658
562563on progress
246558on 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>
 

Watch MrExcel Video

Forum statistics

Threads
1,122,894
Messages
5,598,724
Members
414,253
Latest member
MarieCo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top