conditional formating

**ccsmith** · 07-01-2010, 07:58 AM

Could you help me to modify the next under defined macro? My request is that depending of the value of the column N I need a background change in the same row but just column A.
Example: if cell N9 value is 1 then change the background colour of cell A9 (same row) and so on. Other columns contains more data where i don't need conditional formatting.

Please Login or Register  to view this content.

**romperstomper** · 07-01-2010, 08:09 AM

Try this:

Please Login or Register  to view this content.

**Marcol** · 07-01-2010, 08:16 AM

Try this

Please Login or Register  to view this content.

Are the colour values for 5 & 6 meant to be the same?

Hope this helps

[EDIT]

Added Case Else as per Rs' solution

Go with romperstomper his code allows multi cell selection
Mine is a cop out if more than one cell is selected.

**ccsmith** · 07-01-2010, 08:35 AM

It's working. You are great. Thanks for your help.

**Marcol** · 07-01-2010, 08:58 AM

Maybe a combination of both approaches?

Please Login or Register  to view this content.

This allows Column N to be dynamic, ie you are not restricted to N9:N200

Hope this helps.

[EDIT]
Error in code, detected by romperstomper post #6, corrected

[EDIT 2]
Code now handles multiple deletion of values in N

**romperstomper** · 07-01-2010, 09:03 AM

You seem to be missing an Intersect in there...

**ccsmith** · 07-01-2010, 09:37 AM

Marcol: it seems that your code is working perfectly beacuse my values in N columns derive from other function and change dynamicaly.
Thanks.

**ccsmith** · 07-01-2010, 09:52 AM

running the macro will take some minuts when calculating every row.
Couldn't be set the range limited N9:N200?

**Marcol** · 07-01-2010, 04:20 PM

There was an error in the code I suggested, noticed by romperstomper.
I have corrected this in post #5, rather than post again, there should be no problem with it now.

I have also added the facilty to allow multiple deletion of values in column N

My apologies