![]() |
|
#1
|
|||
|
|||
![]()
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. |
#2
|
||||
|
||||
![]()
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 |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |