Hi,The below article should get you started
http://funwithexcel.blogspot.com/2009/04/macro-for-conditional-formatting-in.html
I have shown clearly how numbers / strings / conditions handled (colored)
using macros. Tweak the code according to your requirements. As far as I
remember color index of Re
Sorry forgot to mention once your conditions are met.. use
Activesheet.Tab.ColorIndex
= 4 (or) Activesheet.Tab.ColorIndex = 2 accordingly. Article shows how to
color the cells not the tabs.
On Fri, May 22, 2009 at 4:42 PM, Aindril De wrote:
> Hi Can you send a sample sheet please
>
> Regards,
>
thank you guys that's just fine!
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.ex
Hi Can you send a sample sheet please
Regards,
Andy
On Fri, May 22, 2009 at 4:02 PM, Mehdi_21 wrote:
>
> hey everyone,
>
> how can i write a macro that colors sheet tab into "red" if:
>
> 1) sheet contains "zero" string
> 2) sheet contains "nine" string
> 3) sheet contains "nine" AND "zero" str
Since the color numbers are different for the different versions of Excel
(Excel 2007 uses some wierd shades)
You'll have to record a macro to find your color numbers.
this macro will get you started.
you need to work on the logic for what you want to do, since what you describe
doesn't really mak
