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
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 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 reply

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
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