cell values base on cell color

[johncena]

Please Login or Register  to view this content.

dear friends above macro work fine.i need to add some color reference code with above macro.

01.column "G" =TP , column "H" = 150D & Column "L" value more than 135 then cell color red.
02.column "G" =TP , column "H" = 300D & Column "L" value more than 150 then cell color green.
03.column "G" & "H" other than above & Column "L" value more than 225 then cell color yellow.

pls make this for me thanks.

[Marcol]

Try

Please Login or Register  to view this content.

P.S.
Dont think its the correct cells I have coloured
but it should be easy to put in say an If statement in your Select Statement

[johncena]

thank u very much Marcol.it's work.thanks a lot again......

[JBeaucaire]

Crosspost:
http://www.mrexcel.com/forum/showthread.php?t=450299

I thought this was solved? You should use regular Conditional Formatting instead of VBA.

[johncena]

Try

Please Login or Register  to view this content.

P.S.
Dont think its the correct cells I have coloured
but it should be easy to put in say an If statement in your Select Statement

Crosspost:
http://www.mrexcel.com/forum/showthread.php?t=450299

I thought this was solved? You should use regular Conditional Formatting instead of VBA.

sorry friend.i have done mistake.this is not solved.above post not included my conditions.(135< ,150< ,225<).he just add colors to cell.

[JBeaucaire]

Try this:

Please Login or Register  to view this content.

[johncena]

[QUOTE=JBeaucaire;2259043]Try this:
[code]Option Explicit

Thanks friends.it's work,thanks a lot again....