Hi, I wanted autofill color on right cell based on left value. Working on Excel 2010
I am making.
A coulum is Equipment
B coulum is description
C coulum is hours.
if C2 coulum is 2 then D2:E3 will set backcolor. If C2 is 1 then set back color only D2. if C2 value is 9 then D2:L2 will set back colour. This will continue up to 12 rows depend on value on C coulum.
Is the above possible make for the conditional fomatting? Sorry I am not expert for the VBA.

Much appreciated for you help.
Please send to my email [email protected]

Hi

Have you checked using conditional formatting in Excel. This should do the changes dynamically

cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)