Previous Topic Next Topic

Fill cells based on the value of other cell

Closed
avanti - Jul 24, 2010 at 04:29 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 26, 2010 at 08:09 AM
Hi,

Please can you help providing macro for the below query..

If I enter a value in a cell say for example I have entered '2' in B4, i want 2 cells i.e B10 and C10 to be filled with a colour-say yellow. Similarly if I enter '4' in C4 then i want D11 to G11 to be filled with green colour.

Thanks

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 26, 2010 at 08:09 AM
You can use conditional format for that

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

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

20 responses
Excel function question
1234ah -
ac3mark -

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

6 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response