Conditional formating, values.

  • Thread starter Thread starter Kasper
  • Start date Start date
K

Kasper

Hi All,

I've been fighting an unfair battle against Excel these past few weeks when
it comes to conditional formating.

It's my personal budget it's all about. Months are horizontally, expenses
vertically. A Total-row displayes the current balance, where a positive
balance is written in white, and a negative balance in yellow. I've done
this using conditional formating, but I'd like my worksheet to turn the
yellow numbers to red, when my creditlimit is used up.

I hope someone here can help me construct the rule for to take effect - I
simply can't get the numbers to turn red when the balance for example
reaches -10.000,-!!

Looking forward in hearing from you...


Best regards

Kasper, Denmark
 
Kasper,

It should be simply achieved by creating a condition of less than or equal
to -10000. The trick is to ensure that that is the first condition, other
the yellow will take effect and that condition will not be tested.
 
Hi Bob,

Thank you for your reply.
I tried back and forth in making a new condition, and couldn't make it work
.... and then suddenly it worked!! :o)
Thanks a lot for your help.


/Kasper
 
Back
Top