Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Conditional formatting based on another cell [Solved/Closed]

Report
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
 -
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
 -
Hello,

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(Arash) at any time without any color effect on B3 cell.
thanks for your help
See more

2 replies

Answer 1 / 2
Posts
1834
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 24, 2020
 135
ArashMan, Good afternoon.

This doubt was solved in your other post.

https://ccm.net/forum/affich-783193-conditional-formatting-based-on-another-cell#4

I'm changing this status post to SOLVED.
Thank you
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Answer 2 / 2
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
 1
thank you so much it helps. I appreciate that.
Ask a question