Conditional formatting???

Closed
Ash - 8 Dec 2014 à 16:07
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 9 Dec 2014 à 12:00
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 12 September 2010 Status Contributor Last seen 27 December 2022 555
9 Dec 2014 à 12:00
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