Color cells based on input

[Closed]
Report
Posts
1
Registration date
Wednesday October 15, 2014
Status
Member
Last seen
October 15, 2014
-
Posts
2786
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 5, 2021
-
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

Posts
2786
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 5, 2021
470
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!