Conditional formatting based on another cell
Solved/Closed
ArashMan
Posts
38
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
-
Dec 15, 2014 at 05:17 AM
ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Dec 17, 2014 at 11:22 PM
ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Dec 17, 2014 at 11:22 PM
Related:
- Conditional formatting based on another cell
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Instagram account based in wrong country - Instagram Forum
- If a cell has text then return value ✓ - Excel Forum
- Based on the values in cells b77 ✓ - Excel Forum
- Excel macro to create new sheet based on value in cells - Guide
4 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 15, 2014 at 07:55 AM
Dec 15, 2014 at 07:55 AM
ArashMan, Good morning.
Try to use:
Apply Conditional Formatting to B3 cell using formula.
=OR($B$6=1,$B$6=2,$B$6=3)
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
Apply Conditional Formatting to B3 cell using formula.
=OR($B$6=1,$B$6=2,$B$6=3)
Is this what you want?
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
Dec 17, 2014 at 12:29 PM
Dec 17, 2014 at 12:29 PM
ArashMan, Good afternoon.
"...this is what I want:
EXAMPLE:
B3= Arash
if B6=1 then B3 goes red
if B6=2 then B3 Goes yellow
and if B6=3 then B3 goes green
i want to change B3 at any time without any effect on the color of B3 cell..."
Now your explanation is clear and precise.
Take a look at an example I did for you:
http://speedy.sh/GZFAM/17-12-2014-en-Kioskea-Conditional-Format-OK.xlsx
ATTENTION:
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
"...this is what I want:
EXAMPLE:
B3= Arash
if B6=1 then B3 goes red
if B6=2 then B3 Goes yellow
and if B6=3 then B3 goes green
i want to change B3 at any time without any effect on the color of B3 cell..."
Now your explanation is clear and precise.
Take a look at an example I did for you:
http://speedy.sh/GZFAM/17-12-2014-en-Kioskea-Conditional-Format-OK.xlsx
ATTENTION:
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
ArashMan
Posts
38
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
Dec 17, 2014 at 11:22 PM
Dec 17, 2014 at 11:22 PM
thank you so much. that helps me a lot.
ArashMan
Posts
38
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
Dec 15, 2014 at 11:27 PM
Dec 15, 2014 at 11:27 PM
EXAMPLE
Dec 15, 2014 at 11:27 PM
thank you for your respond
but this wont helps. is next picture what you mean?
this is what I want:
EXAMPLE:
B3= Arash
if B6=1 then B3 goes red
if B6=2 then B3 Goes yellow
and if B6=3 then B3 goes green
i want to change B3 at any time without any effect on the color of B3 cell