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
- Based on the values in cells b77 b88 ✓ - Excel Forum
- Conditional formatting if cell contains text ✓ - Excel Forum
- How to insert rows in excel automatically based on cell value without vba ✓ - Excel Forum
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- Excel add 1 if cell contains text ✓ - 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