Pinaceous
Well-known Member
- Joined
- Jun 11, 2014
- Messages
- 1,124
- Office Version
- 365
- Platform
- Windows
How do I use conditional formatting in excel to only accept the entries of ONLY the NUMBERS (1, 4, 5, 7, 8) and nothing else?
Where it highlights any CELL that is not one of these entries? (Except the blank!) So a COLUMN might have:
A1• 142425aasj
A2• 424252 asd
A3• asdasd 65566
A4• 1
A5• 4
A6• 5
A7• 7
A8• 8
A9•
A10• 21123123
A11• KJD33
Where it will highlight (A1, A2, A3, A10, A11), where it will not highlight (A4, A5, A6, A7, A8, A9).
I'm working with 'Data Validation' but I need a formula
in using ->
Conditional Formatting
Thank you.
Where it highlights any CELL that is not one of these entries? (Except the blank!) So a COLUMN might have:
A1• 142425aasj
A2• 424252 asd
A3• asdasd 65566
A4• 1
A5• 4
A6• 5
A7• 7
A8• 8
A9•
A10• 21123123
A11• KJD33
Where it will highlight (A1, A2, A3, A10, A11), where it will not highlight (A4, A5, A6, A7, A8, A9).
I'm working with 'Data Validation' but I need a formula
in using ->
Conditional Formatting
Thank you.