Previous Topic Next Topic

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 Contributor 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

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor 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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Input phone lock code
Lucas -
M.Mudasir -

3 responses
Forgotten input phone lock code
jared -
closeup22 -

1 response