Solve : Excel Cond. Formatting: if value >x,shade red. but it also sha

1.	Solve : Excel Cond. Formatting: if value >x,shade red. but it also shades "
Answer» I have a SPREADSHEET with a large SET of numbers/values which includes "<" values (i.e. 1, 1, 2, 1.1, 0.1, <1, 1, 4, <3, etc...). I'm trying to get Conditional Formatting to shade CELL values if they are greater than a value (i.e. shade cell if it's value is greater than 1)... this works great for numbers, but if the cell has a "<" sign in its value, it GETS shaded. Any easy ways to ignore the values (do not shade) with "<" signs? Thanks JGB

Discussion