View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Judy Rose Judy Rose is offline
external usenet poster
 
Posts: 23
Default Conditional Formatting - Getting pass the 3 condition limit

Ok, I tinkered, got the thing to work on the column where the number is
specified that the nums and fnts refer to, also used the with rr that you set
up to indicate for all fonts to use bold and that worked very well, what I
don't understand with the code is what did I do that now for the font it only
shows in the first column, I need the font to also carry across the
row.....didn't see where to put in the reference for jcolor to carry same as
icolor. Not sure where I went wrong....

again thank you for your assistance.
--
Judy Rose Cohen


"Gord Dibben" wrote:

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.