Fill cells based on the value of other cell

Closed

avanti - Jul 24, 2010 at 04:29 PM
rizvisa1

Posts: 4479
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

Fill cells based on the value of other cell
Excel change font color based on value of another cell ✓ - Forum - Excel
Excel macro to create new sheet based on value in cells - Guide
Based on the values in cells b77 b81 ✓ - Forum - Excel
Duplicate rows in excel based on cell value ✓ - Forum - Excel
Excel vba filter based on cell value ✓ - Forum - Excel

1 reply

Answer 1 / 1

rizvisa1

Posts: 4479
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: May 5, 2022

770
Jul 26, 2010 at 08:09 AM

You can use conditional format for that

Subscribe To Our Newsletter!