Conditional formatting???
Closed
Ash
-
Dec 8, 2014 at 04:07 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 9, 2014 at 12:00 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 9, 2014 at 12:00 PM
Hello,
If I enter 1 in a particular cell, I want that cell and the next cell in the row changes to certain colour fill (ex. G5=1, then G5, H5)...
if 2 is entered then, that cell and the next 2 cells must change colour... (ex. G5=2, then G5, H5, I5 changes colour)
if 3 is entered, that and 3 adjacent cells are coloured
and so on...
Please help... Im stuck!!!
If I enter 1 in a particular cell, I want that cell and the next cell in the row changes to certain colour fill (ex. G5=1, then G5, H5)...
if 2 is entered then, that cell and the next 2 cells must change colour... (ex. G5=2, then G5, H5, I5 changes colour)
if 3 is entered, that and 3 adjacent cells are coloured
and so on...
Please help... Im stuck!!!
Related:
- Conditional formatting???
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Code for formatting android phone - Guide
- Excel conditional formatting based on date - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Dec 9, 2014 at 12:00 PM
Dec 9, 2014 at 12:00 PM
Hi Ash,
How far do you want to go?
CF would look like:
You just need to add more rules.
Otherwise you will need a macro.
Best regards,
Trowa
How far do you want to go?
CF would look like:
You just need to add more rules.
Otherwise you will need a macro.
Best regards,
Trowa
