Changing colors

[jackandjill]

Hi i am basically trying to do this i have a value in a1 and b1 and in c1 its basically the minus of a1-b1 and so the difficult part is that i want to compare the values in C column and compare to another value lets just say 11 so if any cell in C column has the value of 11 i want to highlight the A and B cell pertaining to that the C row..

For better understanding

C20 has the value of 11
I want to highlight A11 and B11 only

I was able to get to some extent as u can see below but unable to highlight the A11 and B11 cell

Please Login or Register  to view this content.

Thanks so much

[JeanRage]

Hi,

You can try ... with the reference value say 11 in cell Range("S1")

Please Login or Register  to view this content.

HTH

[jackandjill]

Thank you so much this works just fine...once i dont regret being part of this great community