Color cells based on input

Closed
myexcel.ren Posts 1 Registration date Wednesday October 15, 2014 Status Member Last seen October 15, 2014 - Oct 15, 2014 at 08:02 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 16, 2014 at 10:31 AM
I want to change color of my cells based on an input. eg: If I input 3 in a particular cell, 3 consecutive cells must be highlighted. Any thoughts?

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Oct 16, 2014 at 10:31 AM
Hi Myexcel.ren,

What you are looking for is conditional formatting.

Give it a try and let us know if you get stuck.

Best regards,
Trowa
0