Related:
- Excel conditional formatting w/date range and containing text
- Excel date format dd.mm.yyyy - Guide
- How to clear formatting in excel - Guide
- Excel if range of cells contains specific text then return value ✓ - Excel Forum
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
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
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
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
Jan 12, 2016 at 04:58 AM
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