How to format cells based on the text in another cell
Solved/Closed
Tillda
Tillda
- Posts
- 2
- Registration date
- Thursday October 30, 2014
- Status
- Member
- Last seen
- October 31, 2014
Tillda
- Posts
- 2
- Registration date
- Thursday October 30, 2014
- Status
- Member
- Last seen
- October 31, 2014
Related:
- How to format cells based on the text in another cell
- Formatting cells based on certain criteria ✓ - Forum - Excel
- Format cell color based on date range ✓ - Forum - Excel
- Conditional formatting excel based on text in another cell ✓ - Forum - Excel
- Format cell if another cell contains text ✓ - Forum - Excel
- Excel conditional formatting formula based on another column ✓ - Forum - Excel
1 reply
Mazzaropi
Oct 30, 2014 at 07:18 PM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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