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

  • Thread starter Thread starter sit
  • Start date Start date
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)
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i separate cell value in four different cells? 1
separating single cell value numbers in different cells 1
Delimit using a formula 2 4
MID funtion with conditional format 2
Conditional Formatting 4
MATCH 1
search for dates set by a formula 1
2007 Excel conditional formating, reference cell containing specif 1

Back
Top