|
|
#1
08-09-2015, 12:21 PM
|
|||
|
|||
Conditional Formatting (Detecting Signs/Symbols)
I have a column of cells that have "<3.125", and the new rule I added via conditional formatting is to highlight values that are greater than or equal to 3.125. The values with "<" are highlighted, even though they shouldn't be. Is there any way I can fix this issue so that conditional formatting can detect the "<" without me having to change the values? 
|
|
#2
08-10-2015, 12:20 AM
|
||||
|
||||
|
Perhaps try following CF ( adapt ranges as needed) =and(type(A1)=1,A1>=3.125)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#4
08-10-2015, 11:40 PM
|
||||
|
||||
|
TYPE is an XL function, so yes, you need to type "TYPE". Look it up in XL's help to see what it does
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
| Tags |
| conditional formatting, signs |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help with if and conditional formatting | piper7971 | Excel | 11 | 06-10-2015 12:07 AM |
 Conditional formatting
|
technofrank | Excel | 3 | 06-08-2015 03:15 AM |
|
Conditional formatting that ignores other formatting rules
|
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
|
Conditional formatting with AND, OR
|
Lucky | Excel | 2 | 10-03-2011 11:41 PM |
| Conditional Formatting | namedujour | Excel | 3 | 08-25-2011 01:46 PM |
Windows 7 64bit 
Office 2010 64bit
Linear Mode
