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
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
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
Related:
- Excel based on the values in cells b77 b81
- Based on the values in cells b77 b88 - Excel Forum
- Gif in excel - Guide
- Number to words in excel - Guide
- Dash becomes date on excel ✓ - Office Software Forum
- Excel mod apk for pc - Download - Spreadsheets
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 26, 2010 at 08:09 AM
Jul 26, 2010 at 08:09 AM
You can use conditional format for that
