View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Victor Delta[_2_] Victor Delta[_2_] is offline
external usenet poster
 
Posts: 199
Default Conditional formatting rule precedence difficulties

"Luke" wrote in message
...
The actual formulas a
=OR($A$2=1,$A$2=3) - to format cells as currency
=$A$2=2 - to format cells as integers

Changing the priority of the two doesn't help. If I put the last
condition
in the second position, then all my values stay formatted as integers.
For
some reason, it is getting stuck on that second condition, even without
any
of the "Stop if true" boxes being checked.


Strange! Things I would check:

Presumably the number in A2 is only an integer 0,1,2,3,4?
You could try putting the above formulas (with IFs) in blank cells and just
checking that they do behave as they should.

V