Conditional format macro

**gaurangaero** · 12-14-2012, 05:37 AM

Hello Friends,

I have one excel sheet with colomns C to Q are with conditional format is applied. can anybody help me to create a macro which applied conditional format automatically.I have more then 3000 rows

excel sheet is attached with this thread.

example.xlsx

many thanks,

Gaurang

**Fotis1991** · 12-14-2012, 06:15 AM

I don't thing that you need something else, EXCEPT, to increase the range in your Conditional Formatting rules.

Example: Why only range C2:C6 AND nOT c2:c5000 ??

**gaurangaero** · 12-14-2012, 06:21 AM

Hello Fotis,

I would like somthing like following code see the file also , I found this in the forum digging.....but Don't know how to apply on my excel sheet..

I need because,I am generating this sheet every week...so I have to write this condition every week, if I have some macro so I can run it and make easy my work.

Cond_Format_Macro - NEW.xls

Please Login or Register  to view this content.

**:) Sixthsense :)** · 12-15-2012, 02:16 AM

Try this...

Please Login or Register  to view this content.

**gaurangaero** · 01-02-2013, 05:23 AM

Hello Sixthsense,

please find the excel example sheet on my previous thread, above sheet and code is just exaple that I wish to have like.

Thanks for your repley,

Gaurang

**:) Sixthsense :)** · 01-02-2013, 07:45 AM

The code which I posted will do the same job which you are trying to achieve. If you want to code it in your way then sorry I can't able to help you further.

I hope someone will help you to code it in your way....