I'm sure I'm making this harder than it really is but here's my wish list. I have columns that include some text cells and some data cells. "I wish" for a way to have the font color change to red if a data entry isn't within a certain range. I want to format the entire column this way because I don't know how many entries will be in the column. What I don't wish is for the cells with text to change colors. I know could easily get the data to change to red by highlighting the entire column and using conditional formatting but that changed the cells with text in them to red as well. Example:
Job No.
Lot No.
.305 ±.005
.301
.031
.306
.307
Pass
Pass
.308
So all data in this column between .300 and .310 would be black, text would be black but data <.300 or >.310 would be red.
Job No.
Lot No.
.305 ±.005
.301
.031
.306
.307
Pass
Pass
.308
So all data in this column between .300 and .310 would be black, text would be black but data <.300 or >.310 would be red.