Related:
- Excel conditional formatting w/date range and containing text
- Excel date format dd.mm.yyyy - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
1 reply
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