Formula or VBA code to format certain cells based on the value.

[Seeker2025]

Good day to everyone!

I am looking for a formula that will apply conditional formatting to a certain based on the value in that cell.

I want to create a job pickup time tracker for three shifts in each sheet each day, each with different operators, and upon the duration of the job and the region number of cells to be highlighted.

Example1

Operator-1 picks a 1-hour duration job, and the job is from the UK region

The value I enter is 1-UK1234 were

1 is the 1-hour duration of the job
UK - Is the UK region code
1234 - Is the Job ID which is not standard

Then four cells to be highlighted considering each cell a 15-minute duration.

I have also attached the template and given sample data in this and manually highlighted the cells

But I would like to have a VBA code to highlight as many cells depend on the duration and region.

Pls, refer to my attached screenshot. I wanted to attach the excel workbook, but I think only screenshot I can attach.

I want green color for the UK region jobs, Blue for the US region jobs, Orange for the AP region jobs, Yellow for Break, and Red for Leave.

Cheers.

 

[Logit]

The provided image is very difficult to read. Please post a sample workbook to a download site, then provide the download link here. Thank you.

 

[Seeker2025]

The provided image is very difficult to read. Please post a sample workbook to a download site, then provide the download link here. Thank you.

 

[Seeker2025]

Hi, thanks for your reply. As I am new to this forum, could you please guide me on where to find the download site.

 

[Logit]

This forum doesn't provide that service. You'll need to use an outside website (DropBox.com, etc) then provide the download link here.

 

[Seeker2025]

This forum doesn't provide that service. You'll need to use an outside website (DropBox.com, etc) then provide the download link here.

Google Drive: Sign-in

Access Google Drive with a Google account (for personal use) or Google Workspace account (for business use).

drive.google.com

 

[Seeker2025]

Google Drive: Sign-in

Access Google Drive with a Google account (for personal use) or Google Workspace account (for business use).

drive.google.com

Loading Google Sheets

 

[Peter_SSs]

The link says "You need access".
Google's instructions for sharing a file publicly:

 

[Logit]

I don't see the example workbook you are using for this project.

 

[Seeker2025]

PickupTracker.xlsx

docs.google.com