Highlighting Cells based on Dates of other ce

Closed

Dave - 8 Feb 2011 à 07:47
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 9 Feb 2011 à 09:06

Hello,

I am working on the following. I have names of customers in column A and dates in columns B, D, F, H, J and L. I am trying to highlight the name if any of the dates are within 30 days of today's date. Can anyone help me? Thanks!!

Highlighting Cells based on Dates of other ce
Based on the values in cells b77 - Excel Forum
Based on the values in cells b77 b88 ✓ - Excel Forum
How to extract data from excel based on criteria - Excel Forum
Vivatech 2024 dates - Guide
How to change account based in instagram - Instagram Forum

1 response

Réponse 1 / 1

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
8 Feb 2011 à 12:22

you can use conditional format to do that.

Dave
9 Feb 2011 à 09:01

Do you know what formula to use. I have tried several but to no avail. Thanks.

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
9 Feb 2011 à 09:06

Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.

Note: your data need not be to be real data but a good representative of how data looks like

Similar discussions

Fill adjacent cell with number from text answer

help me to add particular cells

Clear cell contents based on value of another cell range using VBA

Excel function question

Name Values

Similar discussions

Subscribe To Our Newsletter!