Conditional Fornmatting Text and numbers
If you want to highlight fields which are TEXT i.e. are not blank or numeric
, use:
=TEXT($A1) for your CF
HTH
"Wanna Learn" wrote:
Hello this is my conditional formating = " " and this works fine except
that when there is a number in the cell it does not work. How can I do this
without having to convert the numbers to text? thanks
|