Cell colour containing specific info
Solved/Closed
JohannGC
Posts
3
Registration date
Thursday June 22, 2017
Status
Member
Last seen
June 23, 2017
-
Updated on Jun 22, 2017 at 04:06 AM
JohannGC - Jun 23, 2017 at 09:00 AM
JohannGC - Jun 23, 2017 at 09:00 AM
Related:
- Cell colour containing specific info
- Crimping colour code - Guide
- How to find specific words on a page - Guide
- Potplayer hide info - Guide
- Radio info code - Guide
- How would you change all cells containing the word pass to green - Excel Forum
3 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 22, 2017 at 07:45 AM
Jun 22, 2017 at 07:45 AM
JohannGC, Good morning.
Try to use:
Select AA4
Menu Conditional Format
Using formula
--> =B4="Z"
--> Format: Fill color as GREEN
OK
Please, tell us if it worked as expected.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
Select AA4
Menu Conditional Format
Using formula
--> =B4="Z"
--> Format: Fill color as GREEN
OK
Please, tell us if it worked as expected.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 22, 2017 at 10:36 AM
Jun 22, 2017 at 10:36 AM
JohannGC,
"... Is there a formula I can use to set it as containing Z or starting with Z?..."
Yes.
Starting with Z
=LEFT(B4,1)="Z"
Containing Z
=ISNUMBER(SEARCH("Z",B4))
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
"... Is there a formula I can use to set it as containing Z or starting with Z?..."
Yes.
Starting with Z
=LEFT(B4,1)="Z"
Containing Z
=ISNUMBER(SEARCH("Z",B4))
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
JohannGC
Posts
3
Registration date
Thursday June 22, 2017
Status
Member
Last seen
June 23, 2017
Jun 23, 2017 at 02:29 AM
Jun 23, 2017 at 02:29 AM
Hi Marcilio,
Thank you for the reply. When I use those formulas I receive the error saying "there is a problem with this formula." and help states that Excel does not understand what I am trying to do.
I followed the following steps.
1. I select the AA4 cell (the cell I want to change the colour)
2. Conditional Formatting ----> New Rule ----> Use a formula to determine which cells to format.
3. Format values where this format is true ----> =LEFT(B4,1)="Z"
I am not sure why it does this.
Regards
Johann
Thank you for the reply. When I use those formulas I receive the error saying "there is a problem with this formula." and help states that Excel does not understand what I am trying to do.
I followed the following steps.
1. I select the AA4 cell (the cell I want to change the colour)
2. Conditional Formatting ----> New Rule ----> Use a formula to determine which cells to format.
3. Format values where this format is true ----> =LEFT(B4,1)="Z"
I am not sure why it does this.
Regards
Johann
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 23, 2017 at 08:36 AM
Jun 23, 2017 at 08:36 AM
Johann, Good morning.
Your procedure is correct.
I'm guessing that your version of Excel is in English.
However, depending on the country, the parameter separator can be the comma "," or the semicolon ";".
Do your formulas use a comma or a semicolon?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Your procedure is correct.
I'm guessing that your version of Excel is in English.
However, depending on the country, the parameter separator can be the comma "," or the semicolon ";".
Do your formulas use a comma or a semicolon?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Jun 22, 2017 at 08:09 AM