conditionally format a cell based on a value in another, and the date.

lbradbury

New Member
Joined
May 14, 2020
Messages
31
Office Version
  1. 365
Platform
  1. Windows
Hello,

I'm looking to conditionally format a date cell to be highlighted based on two conditions.
The first being date in the cell exceeds a week highlight the cell, but only if another cell value doesn't equal 0,1. An example below, Column M has the dates that are to be conditionally formatted if they are past a week, but not if column T has a value of 0 or 1.


Column M Column T
Anticipated Notification DateWon (1) Loss (0)
6/30/2020​
0
6/30/2020​
0
6/30/2020​
0
 

Some videos you may like

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.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,868
Office Version
  1. 365
Platform
  1. Windows
How do you determine if the date in col M has exceeded a week?
 

lbradbury

New Member
Joined
May 14, 2020
Messages
31
Office Version
  1. 365
Platform
  1. Windows
Just using the conditionally formatting highlighting feature formatting the cell that contains a date occurring last week.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,868
Office Version
  1. 365
Platform
  1. Windows
So are you basing it on today's date?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,752
Messages
5,574,031
Members
412,564
Latest member
tana
Top