Question data validation with conditional formatting

Bolt12

New Member
Joined
Aug 20, 2019
Messages
1
I am trying to figure out if there is a way to use conditional formatting with data validation list like this.

1st I have a list from data validation of performing a task.
I will use 4 task that I do once a week.
Mow grass, wash dishes, wash car, clean pool
I want to set a time for each, and show a conditional format for each objective to show green/red for pass/fail.

Example:
mow grass takes 2 hours.
1st week I did it in 1hr 58 mins (green)
2nd week 2hr 22min (red)

Wash dishes takes on average 30 min
1st week I did it in 45 min (red), 2nd week 48 min (still red)

Wash car-45min
1st week 1hr (red), 2nd week 37 min (green)

Clean pool-2hrs
1st week 1hr 30 min, 2nd week 1hr 15min

What I want to do is have a data validation list with my task.
Mow grass, wash dishes, wash car, clean pool.
Click the arrow down and 1st one up is mow grass and my results are below.

show red/green on all the task that I have.

Select wash dishes, and in the same result area show the new results with red/green.
I already setup the data formula with a vlookup, so the data is there with the change in data each selection I make. I already know how to do the data validation list. I just want to see red/green to match the objectives without having to have 4 different lines with the different data sets on it.
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

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
Back
Top