Excel conditional formatting w/date range and containing text [Closed]

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

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.

See more 

2 replies

Mazzaropi 1698 Posts Monday August 16, 2010Registration dateContributorStatus January 22, 2018 Last seen - Sep 25, 2015 at 10:01 AM
0
Helpful
1
debbie, Good morning.

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

Example:

=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