Macro to Change the colour of cell based on text

**rakeshplb** · 04-25-2009, 11:44 AM

Hi all,

I want a macro which can change the colour of cell based on text.

The selected range has values like -

1673030
1673020
1674020
1674030

In the selected range if the fourth charactor is "4" then cell should be coloured in blue, else in red.

Can anybody help me please.

**royUK** · 04-25-2009, 11:56 AM

You could use the WorkSheet_Change event

Please Login or Register  to view this content.

**rakeshplb** · 04-25-2009, 12:18 PM

Hi royUK

the code is not working here.
Can you please give the complete sub procedure.

What is WorkSheet_Change event?

I just want to recolour cell in the selected range. Please help.

Thanks!

**royUK** · 04-25-2009, 01:10 PM

If you just want a macro to run on a selected range

Please Login or Register  to view this content.

**rakeshplb** · 04-25-2009, 01:47 PM

Great thanks!

But i still dont understand what your original code was?

Thanks!

**royUK** · 04-26-2009, 04:17 AM

The original code is a sheet event, when a cell is changed the code runs. Try using the xcel VBA help files an explanation.

Macro to Change the colour of cell based on text

LinkBack

Thread Tools

Rate This Thread

Display

Macro to Change the colour of cell based on text

Re: Macro to Change the colour of cell based on text

Re: Macro to Change the colour of cell based on text

Re: Macro to Change the colour of cell based on text

Re: Macro to Change the colour of cell based on text

Re: Macro to Change the colour of cell based on text

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions