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
- Format cell with text and number - How-To - Excel
- How to clear format cell in excel - How-To - Excel
- Format cell phone - How-To - Android
1 reply
Mazzaropi
- Posts
- 1868
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- January 15, 2021
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.
Report
Tillda
- Posts
- 2
- Registration date
- Thursday October 30, 2014
- Status
- Member
- Last seen
- October 31, 2014
Yes, it worked! Thank you!
Subscribe To Our Newsletter!
