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
- How to change date format in excel - Guide
- Based on the values in cells b77 ✓ - Excel Forum
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Format factory - Download - Other
- Return Seq Values Until Blank value then return different set of seq values ✓ - Excel Forum
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