conditional format

[Jean-Paul]

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

 

[ck13]

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]

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]

Try
=OR(A1=5,B1=5,C1=5,D1=5,E1=5,F1=5,G1=5,H1=5,I1=5,J1=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]

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]

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.