Previous Topic Next Topic

Excel conditional formatting w/date range and containing text

Closed
debbie - Sep 25, 2015 at 09:17 AM
 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.

Related:

1 response

Answer 1 / 1
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.

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
0
Dani
Jan 12, 2016 at 04:58 AM
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
0

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses