Conditional Formatting different due dates

abadbrad

New Member
Joined
Aug 5, 2019
Messages
2
I have looked and tried, and no luck.

I need A3 to do 2 things
When the arrival date is less than the number of days allowed to turn red.
so it will turn red when a date is entered and also turn red automatically using today's date.

A1 has arrival date
A2 Has drop down list with 1 day, 3 day, 5 day. (I can remove "day", if that helps) (same document sheet called Data)

A3 to turn red...this is where I'll add the received date
ArrivalAllowed daysarrived
08/01208/05
08/013Cell filled red

<tbody>
</tbody>
Both cell are filled red, I didn't see an option.
Excel 2010 & 2013

Thanks Excel Wonder workers...I'm about 2 hours into trying ..no luck
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Welcome to the Board!

You say cells A1, A2, and A3, but from your image, those would be columns A, B, and C, not row 1, 2, and 3.

Let's say that you have Arrival in A2, Allowed Days (just number, no "days" in text) in cell B2, and Arrived in cell C2.
Then, you could use this Conditional Formatting Formula on cell C2:
Code:
=(A2+B2) < MAX(C2,TODAY())
and choose your red formatting option.

To apply it to a whole range of cells in column C, select the whole range you want to apply it to, then enter the formula as it pertains to the very first cell in your selection. Excel will automatically adjust the formula for the other cells/rows in your selection.
 
Upvote 0
You are welcome.
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,953
Members
448,535
Latest member
alrossman

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