If statement....

Miler13

New Member
Joined
Feb 5, 2017
Messages
43
So I have a list if things in a sheet. In the A column there are names, B column has a date, C column has a number and the D column has another date which is 5 days from the date in column B. I want to be able to come up with something that when someone's name is written into column A and if the date that gets placed into column D is within 5 days of the previous date of the same person in column D it will highlight the D column a color.
Example
Eric m ---- 6/25/21 ------ 3 --------- 6/30/21

Now if I enter that same name and the date in the second column is 6/27/21, I want the date that gets placed in column D to be highlighted.
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Radoslaw Poprawski

Active Member
Joined
Jun 19, 2021
Messages
326
Office Version
  1. 365
Platform
  1. Windows
please provide minisheet with current data
please provide minisheet with expected result

say both 10 rows.
 

Miler13

New Member
Joined
Feb 5, 2017
Messages
43
how to do i do that? i downloaded xl2bb and copied it into a mini sheet, but it wont let me post it anywhere?
 

Radoslaw Poprawski

Active Member
Joined
Jun 19, 2021
Messages
326
Office Version
  1. 365
Platform
  1. Windows
use
1624746781595.png
en simply ctrl+v in the reply window and post
 

Forum statistics

Threads
1,147,475
Messages
5,741,344
Members
423,656
Latest member
Medrok2021

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
Top