conditional formatting problem

  • Thread starter Thread starter IOTP
  • Start date Start date
I

IOTP

I am trying to get an excel invoice to recognize negative numbers. I'v
only got one condition running and it is "cell value is between -100
and 1000" It is still not recognizing it! What else do I need to do
help!!!:confused
 
Hi
this should normally do. Have you checked that your cell is NOT
formated as 'Text'
 
No, it's formatted as currency. I know I used conditional formatting t
fix this before, and now that I know how to use it, it's not working!
this is crazy, i hope someone can help
 
Hi
if you like mail me an example of this and I'll have a look at it
email: frank[dot]kabel[at]freenet[dot]de
 
Back
Top