How to format cells based on the text in another cell
Solved/Closed
Tillda
Posts
2
Registration date
Thursday October 30, 2014
Status
Member
Last seen
October 31, 2014
-
Oct 30, 2014 at 06:14 PM
Tillda Posts 2 Registration date Thursday October 30, 2014 Status Member Last seen October 31, 2014 - Oct 31, 2014 at 04:30 PM
Tillda Posts 2 Registration date Thursday October 30, 2014 Status Member Last seen October 31, 2014 - Oct 31, 2014 at 04:30 PM
Related:
- How to format cells based on the text in another cell
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Compare 2 text cells and show difference in the third cell ✓ - Excel Forum
- Excel date format dd.mm.yyyy - Guide
- Count if cell contains number - Excel Forum
- Excel macro to create new sheet based on value in cells - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 30, 2014 at 07:18 PM
Oct 30, 2014 at 07:18 PM
Tillda, Good evening.
Are you trying to highligh the cells if F5 is New Hire OR Promotion?
If Yes, try to use it:
=OR($F$5="New Hire",$F$5="Promotion")
Is it what you want?
I hope it helps.
Are you trying to highligh the cells if F5 is New Hire OR Promotion?
If Yes, try to use it:
=OR($F$5="New Hire",$F$5="Promotion")
Is it what you want?
I hope it helps.
Oct 31, 2014 at 04:30 PM