Conditional formatting... more?
 

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?

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?

Conditional formatting... more?
 

Yikes... that sounds like I'd have to learn macros and visual basic... *gulp*

"Don Guillett" wrote:

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?

Conditional formatting... more?
 

see http://www.mvps.org/dmcritchie/excel/event.htm#case
directions to install an event macro are earlier on the page, but it is
right click on the worksheet tab, then view code, and place code there.

For those that would rather use an addin that extends the limit of 3 Conditional Formatting conditions per cell you take a look at
CFPlus - Extended Conditional Formatter, Bob Phillips
http://www.xldynamic.com/source/xld.....Download.html
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"mikeweasel" wrote in message ...
Yikes... that sounds like I'd have to learn macros and visual basic... *gulp*

"Don Guillett" wrote:

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?