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

Excel based on the values in cells b77 b81
Based on the values in cells b77 b88 ✓ - Excel Forum
Based on the values in cells b77 b81 what function can automatically return the value in cell c77 ✓ - Excel Forum
Looking For a Value in a Cell - Excel Forum
Excel mod apk for pc - Download - Spreadsheets
Dash becomes date on excel ✓ - Office Software Forum

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

Fill adjacent cell with number from text answer

Clear cell contents based on value of another cell range using VBA

Excel function question

Name Values

Similar discussions

Subscribe To Our Newsletter!