Beddy Boy
New member
- Joined
- Feb 1, 2017
- Messages
- 48
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 365
Hi,
I wish to highlight certain cells in a sheet dependent on a value I input into a cell.
I have tried using conditional formatting that works OK except when I use the number 1, cells that contain "1" are all highlighted eg 10, 11, 12 etc.
How can I fix this ??
Many thanks
I wish to highlight certain cells in a sheet dependent on a value I input into a cell.
I have tried using conditional formatting that works OK except when I use the number 1, cells that contain "1" are all highlighted eg 10, 11, 12 etc.
How can I fix this ??
Many thanks