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

Conditional formatting???
Excel conditional formatting if another cell contains specific text - Excel Forum
How to clear formatting in excel - Guide
To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
Excel formula to change cell color without conditional formatting - Excel Forum
Phone formatting software for pc - Download - File management

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Highlight cell if another cell contains any text

Conditional formating - apply on more cells

one cell will turn green when the two other cells match

Similar discussions

Subscribe To Our Newsletter!