Change cell colour based on other cells text Closed

Question

Hello, I really need help on this one as I can't work it out.

I need to change the colour of a cell if that cell and the previous 12 cells do not contain specific text.
I need to be able to apply this to a selection of cells in a sheet, not all of them. 
I have worked out that it is done through conditional formatting but I cannot work out the formula to use to enable it.




Configuration: Windows XP / Chrome 47.0.2526.106

Mazzaropi · Answer

nikbak, Good morning. 

Suppose:

Select M1
Conditional Format Menu --> Using formula

=ISERROR(MATCH("OK",A1:M1,0))

Choose Fill Color as you want
OK

If you want copy this FORMAT to others cells...

Select M1 --> COPY

Select M3 , M7 , O9 , Q12

SPECIAL PASTE --> FORMAT --> OK

Is this what you want?
I hope it helps. 
 --
Belo Horizonte, Brasil.
Marcílio Lobão

Change cell colour based on other cells text

1 response

Similar discussions

Subscribe To Our Newsletter!