Can i use conditional formating on a cell when it contains a formula?

F

Frank Kabel

Hi
the reason for this is that thie formula returns a string and not a
numeric value. Change the formula to:
=--mid(text(a1;"0000000000.00");1;1)
 
R

RagDyeR

OR ...

Change your Conditional formula to:

="0"

*IF* you really want the characters to remain as text.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi
the reason for this is that thie formula returns a string and not a
numeric value. Change the formula to:
=--mid(text(a1;"0000000000.00");1;1)
 
Top