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
.

.