Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-02-2025, 10:36 PM
Seeker2025 Seeker2025 is offline Formula or VBA code to format certain cells based on the cell value Windows 11 Formula or VBA code to format certain cells based on the cell value Office 2021
Novice
Formula or VBA code to format certain cells based on the cell value
 
Join Date: Feb 2025
Posts: 2
Seeker2025 is on a distinguished road
Default Formula or VBA code to format certain cells based on the cell value

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 that many 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.

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.
Attached Files
File Type: xlsx PickupTracker.xlsx (50.4 KB, 5 views)
Reply With Quote
  #2  
Old 02-03-2025, 01:14 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Formula or VBA code to format certain cells based on the cell value Windows 11 Formula or VBA code to format certain cells based on the cell value Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Hi and welcome to the board.
Your thread title states : " Formula or VBA code ..."
But your body text states :"But I would like to have a VBA code .."
Which do you want? VBA or a formula ? ( VBA is another subforum)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula or VBA code to format certain cells based on the cell value Need formula to format one cell if another cell includes specific text Bigsur2 Excel 2 11-17-2022 11:53 AM
Need the Chart and format based on my data using VBA code ganesang Excel Programming 0 03-03-2021 04:30 AM
Formula for Overtime based off the sum of 2 cells kae2011 Excel 6 07-03-2018 12:06 AM
Merging 2 different cells containing IF formula & change in cell values based on multiple time frame jay_excel Excel 0 07-29-2017 11:04 PM
Change formula cell range based on cell value Scoth Excel 4 10-25-2012 07:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft