Highlighting Cells based on Dates of other ce

Closed

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

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
Different dates of "end to end encryption message" on blank chat? ✓ - Excel Forum
Ce-42288-4 - PS3 & PS4 Forum
Based on the values in cells b77 ✓ - Excel Forum
Excel macro to create new sheet based on value in cells - Guide
PS4 Error Code CE-42288-4 - PS3 & PS4 Forum

1 response

Answer 1 / 1

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

you can use conditional format to do that.

Dave
Feb 9, 2011 at 09:01 AM

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

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

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

help me to add particular cells

encryption message several time in chat

Fill adjacent cell with number from text answer

Instagram highlights not loading

Excel function question

Similar discussions

Subscribe To Our Newsletter!