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
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,707
Office Version
365
Platform
Windows
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.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,707
Office Version
365
Platform
Windows
You are welcome.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,678
Messages
5,488,223
Members
407,632
Latest member
varunwalla

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top