View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Conditional Formatting - Getting pass the 3 condition limit

Thanks for the feedback.

You can alter the fnts = Array(2, 3, 4, 5, 6, 7, 8, 9, 10, 11)

fnts = Array(2, 3, 2, 2, 2, 2, 5, etc) to match just the darker or lighter nums
array

A lot of fiddling but can be done.


Gord

On Tue, 20 May 2008 10:03:00 -0700, Judy Rose
wrote:

Thank you again, guess you didn't see my follow up post where I was asking
precisely how to do what you just described. Thank you again for all of your
help. This should work very nicely.