Report

Change cell colour based on other cells text

Ask a question nikbak - Latest answer on Sep 22, 2016 09:39AM
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.
See more 
Helpful
+0
moins plus
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
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!