Hi,

I want the color of the text in cell B1 to change depending on the value
in cell A1
How can this be done?

I know I can do it with conditionale format for the cell itself but not
for another one.

Thanks

JP

Try this. Assume you want B1 text to change colour when the value in A1 is 5,
select B1 and go to conditional formatting. In the condition, select 'Formula
is' then in the empty space, type =A1=5 choose the font colour that you want.

"Jean-Paul" wrote:

Hi,

I want the color of the text in cell B1 to change depending on the value
in cell A1
How can this be done?

I know I can do it with conditionale format for the cell itself but not
for another one.

Thanks

JP
.

perfect, but what if I want it to depend on 15 cells???

I thought to write in the formula:

= A1=5 or B1=5 or c1=5 or d1=5 and so on

Thanks

ck13 wrote:
Try this. Assume you want B1 text to change colour when the value in A1 is 5,
select B1 and go to conditional formatting. In the condition, select 'Formula
is' then in the empty space, type =A1=5 choose the font colour that you want.

"Jean-Paul" wrote:

Hi,

I want the color of the text in cell B1 to change depending on the value
in cell A1
How can this be done?

I know I can do it with conditionale format for the cell itself but not
for another one.

Thanks

JP
.

Try
=OR(A1=5,B1=5,C1=5,D1=5,E1=5,F1=5,G1=5,H1=5,I1=5,J 1=5,K1=5,L1=5,M1=5,N1=5,O1=5)

another formula you can try =COUNTIF($A$1:$O$1,5)=1


"Jean-Paul" wrote:

perfect, but what if I want it to depend on 15 cells???

I thought to write in the formula:

= A1=5 or B1=5 or c1=5 or d1=5 and so on

Thanks

ck13 wrote:
Try this. Assume you want B1 text to change colour when the value in A1 is 5,
select B1 and go to conditional formatting. In the condition, select 'Formula
is' then in the empty space, type =A1=5 choose the font colour that you want.

"Jean-Paul" wrote:

Hi,

I want the color of the text in cell B1 to change depending on the value
in cell A1
How can this be done?

I know I can do it with conditionale format for the cell itself but not
for another one.

Thanks

JP
.

.

extra question...

I don't know how many columns I will have... sometimes it will go to
column K, sometimes to column O or V or whatever
What I'm sure of is that there will be an empty cell next to the last one...
Is there a way to implement this in your CountIf formula?

Thanks

JP

ck13 wrote:
Try
=OR(A1=5,B1=5,C1=5,D1=5,E1=5,F1=5,G1=5,H1=5,I1=5,J 1=5,K1=5,L1=5,M1=5,N1=5,O1=5)

another formula you can try =COUNTIF($A$1:$O$1,5)=1


"Jean-Paul" wrote:

perfect, but what if I want it to depend on 15 cells???

I thought to write in the formula:

= A1=5 or B1=5 or c1=5 or d1=5 and so on

Thanks

ck13 wrote:
Try this. Assume you want B1 text to change colour when the value in A1 is 5,
select B1 and go to conditional formatting. In the condition, select 'Formula
is' then in the empty space, type =A1=5 choose the font colour that you want.

"Jean-Paul" wrote:

Hi,

I want the color of the text in cell B1 to change depending on the value
in cell A1
How can this be done?

I know I can do it with conditionale format for the cell itself but not
for another one.

Thanks

JP
.

.

You can set the range to as many as you want. Basically what the formula does
is that it will see the range that you set and count how many of the cells
have a value 5. So long as there is at least 1 cell with value 5, it will
cause the cell in B1 to change colour. So my advice is that if you are not
sure how many columns it will go, select the maximum range.

"Jean-Paul" wrote:

extra question...

I don't know how many columns I will have... sometimes it will go to
column K, sometimes to column O or V or whatever
What I'm sure of is that there will be an empty cell next to the last one...
Is there a way to implement this in your CountIf formula?

Thanks

JP

ck13 wrote:
Try
=OR(A1=5,B1=5,C1=5,D1=5,E1=5,F1=5,G1=5,H1=5,I1=5,J 1=5,K1=5,L1=5,M1=5,N1=5,O1=5)

another formula you can try =COUNTIF($A$1:$O$1,5)=1


"Jean-Paul" wrote:

perfect, but what if I want it to depend on 15 cells???

I thought to write in the formula:

= A1=5 or B1=5 or c1=5 or d1=5 and so on

Thanks

ck13 wrote:
Try this. Assume you want B1 text to change colour when the value in A1 is 5,
select B1 and go to conditional formatting. In the condition, select 'Formula
is' then in the empty space, type =A1=5 choose the font colour that you want.

"Jean-Paul" wrote:

Hi,

I want the color of the text in cell B1 to change depending on the value
in cell A1
How can this be done?

I know I can do it with conditionale format for the cell itself but not
for another one.

Thanks

JP
.

.

.