Change cell colour based on other cells text
Closed
nikbak
-
Sep 22, 2016 at 09:23 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 22, 2016 at 09:39 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 22, 2016 at 09:39 AM
Related:
- Change cell colour based on other cells text
- Crimping colour code - Guide
- Change computer name cmd - Guide
- Change lg tv name - Guide
- Count if cell contains number - Excel Forum
- Excel macro to create new sheet based on value in cells - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 22, 2016 at 09:39 AM
Sep 22, 2016 at 09:39 AM
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
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