If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
conditional format
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 |
#2
|
|||
|
|||
conditional format
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 . |
#3
|
|||
|
|||
conditional format
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 . |
#4
|
|||
|
|||
conditional format
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 . . |
#5
|
|||
|
|||
conditional format
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 . . |
#6
|
|||
|
|||
conditional format
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 . . . |
Thread Tools | |
Display Modes | |
|
|