Excel conditional formatting w/date range and containing text

debbie - Sep 25, 2015 at 09:17 AM
 Dani - Jan 12, 2016 at 04:58 AM

I need to make a conditional format based on the date in a cell being between 30-60 days past today's date and only if another cell contains text than apply conditional formatting to that cell. HELP Not sure how to write this. I did figure out a way to do the conditional formatting based on the dates but can not figure how to add the next condition of containing text from another cell to it.


1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 25, 2015 at 10:01 AM
debbie, Good morning.

Try to use an AND Function at your formula in RULE of Conditional Format.


=AND(first conditon-DATE , second condition-TEXT)

Is that what you're looking for?
I hope it helps.
Belo Horizonte, Brasil.
Marcílio Lobão
Ola Marcilio,

Maybe you can help me please?

I've a project timeline where I put the start and the end of a task. I managed to create a conditional formatting for the period between these dates. The cells in the calendar highlights as I add the start and end.
However, I also need those cells to identify the resource I'm selecting from a drop down list with different colour formatting for each resource. So to summarise I need:

Conditional formatting on the calendar weeks/month as per date.
Conditional formatting on the calendar weeks/month as per resource.

Is that clear?

Obrigada!! Daniella