Condtional Formatting- Color Scale

[Shay A]

Hi,
I can't upload a file at the moment but let me describe to you what I need:
Shay aaaaaa 45
Shay fhhhgj 56
Shay hffgh 68
How can I apply color scale on the entire row and not just on clumn C. Imagie that the values 45, 56 and 68 are in cells c1, c2 and c3 respectively.

Thank you

 

[Khalid NGO]

Hi,

Select ROW(1:3), Go to conditional formatting > New Rule > Use a Formula:

=AND(SEARCH("*56",$C$2),SEARCH("*56",$C$2),SEARCH("*68",$C$3))

Format to your need.

Regards,

 

[Shay A]

Hi,
But the automatic color scaling is what I'm after...
TY again

 

[Khalid NGO]

Hi,

I think color scale does not work with strings (and does not format entire row formatting based on one column).

Not sure, may be there is a way in VBA.

Regards,

 

[Shay A]

Maybe you could help me with a code to color code the rest of the row.

Range("C1").interior.color...

Thanks

 

[Khalid NGO]

Maybe you could help me with a code.

Hi,

Someone may help you as VBA is really not my cup of tea

Regards,

 

[Shay A]

Hi,
Sp should I post it again in the VBA forum?

TY,
Shay

 

[Khalid NGO]

should I post it again in the VBA forum?

Hi,

Not necessary.
Wait someone to post VBA solution here.

Regards,


Edit: Question moved to VBA