Excel conditional formatting w/date range and containing text

Closed
Report
-
 Dani -
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.

1 reply

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
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