Smokeyham
Board Regular
- Joined
- Feb 1, 2006
- Messages
- 120
- Office Version
- 365
- Platform
- Windows
Hello,
This should be simple to do, but for some reason it is not working for me. I have a series of numbers, which are actually formatted as text:
28-01
28-02
28-03 etc....
The numbers repeat after they get to 26, except in certain circumstances where there is a 27th number (28-27)
When that happens, I want to use conditional formatting to highlight that cell.
Here is the "formula" I am using in the conditional formatting =ISNUMBER(27). This works, but unfortunately when I use it any other cell, it also highlights the value regardless of wether or not 27 is in the cell.
Any thoughts on how I can get conditional formatting to limit itself to only cells where the "27" is present?
Thanks in advance for any help.
This should be simple to do, but for some reason it is not working for me. I have a series of numbers, which are actually formatted as text:
28-01
28-02
28-03 etc....
The numbers repeat after they get to 26, except in certain circumstances where there is a 27th number (28-27)
When that happens, I want to use conditional formatting to highlight that cell.
Here is the "formula" I am using in the conditional formatting =ISNUMBER(27). This works, but unfortunately when I use it any other cell, it also highlights the value regardless of wether or not 27 is in the cell.
Any thoughts on how I can get conditional formatting to limit itself to only cells where the "27" is present?
Thanks in advance for any help.