Forum Discussion

Francie1991's avatar
Francie1991
Copper Contributor
Aug 11, 2022

Formatting

How do I conditional format cells that are greater than a number but have both letters and numbers where the letters/words do not highlight?

 

Thanks

 

Frances

 

excel

1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    Aug 11, 2022
    are you trying to highlight parts of cell and not other parts (not possible)
    or are you saying in the list/column you are checking there are cells that are not numeric? this is possible:
    under conditional formatting select custom formula then
    =ISNUMBER(A1)*(A1>10)
    would highlight A1 if it is a number AND > 10
    make sure your formula is based on the upper left cell in the applied to range using $ to 'lock' the row/column if needed and do not use $ when you want the reference to be relative.

Resources