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
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!!!

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
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
0