View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Conditional formatting... more?

How about a worksheet_change event using select case

--
Don Guillett
SalesAid Software

"mikeweasel" wrote in message
...
Does anyone have any kind of clever workaround to get past the three
format
limit? I'm using Excel 2003. I've created a random fractal "landscape"
generator and would like to indicate different elevations with different
formats. But 3 is fairly limited.

One method is to ignore the sheet itself and instead use a surface chart,
but then the elevation lines all have to be in even increments.

Any ideas?