Automatically add Text and fill color green in Cell

[MikePoolDancer]

Hello

If value in cell A3 is bigger then value in cell A2 then in cell A1 should get filled with in green color and Text Q automatically.


could you please advice ?

Have a wonderful day

 

[MikePoolDancer]

Well for my visibility is it the best.

thank you and enjoy the rest of Day, i like this FORUM

 

[awoohaw]

Well for my visibility is it the best.

thank you and enjoy the rest of Day, i like this FORUM

you;re welcome. I'm pleased you like the forum.
I must admit, my last post was horribly written, my apologies. I hope you made some since of it and that you have a solution that works for you.

 

[MikePoolDancer]

Good Morning


I tried the version when both number are equal in cell A3 cell value 1 and cell A2 value 1 then cell A1 sould get fill color green and text Q. Does the formula then look like this ? Wich doesn t work...

AND(A3“=“A2,A1="Q")
OR
AND(A3"<" or “>”A2,A1="Q")

you give me those signs but you didn t show where to put them:

• “=“
• "<" or “>”

Have a nice morning

 

[awoohaw]

I'm really unsure of your objective with your question. What are you trying to learn with this question?

But, look at this and reply with if it is as you want.
You want a Q in cell A1:
IF
1. A2>A3
2. A3>= A2
3. A2 = 1, and A3 = 1
(so, the only time you don't want a "Q" in A1 is when:

A2=A3, A2<>1 )​

and for cell coloring
you want Red when A2>A3
you want Green when A3>=A2

Book1
	A
1	Q
2	2
3	2
Sheet3

Cell Formulas
Range	Formula
A1	A1	=IF(OR(A2>A3,AND(A2=1,A3=1),A3>=A2),"Q","")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	Expression	=AND(A2>A3,A1="Q")	text	NO
A1	Expression	=OR(AND(A3>=A2,A1="Q"),AND(A2=1,A3=1))	text	NO