View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default Multiple Conditonal Formats

Set up your first condition and associated format, then hit the "Add" button
in the conditional formatting dialogue box.
--
David Biddulph

"Dave" wrote in message
oups.com...
I know how to use this in basics, say when the cell equals 1 change
colour to blue. How would you how ether change the colour again in the
same cell if the value was say 3, change it to green and so on?