Home |
Search |
Today's Posts |
#1
|
|||
|
|||
insert text conditionally and format
Hi,
I want to conditionally format a cell so that it turns red based on another's value. Actually, if any one of 3 cells are out of a specified value, then this 4th cell should turn. This much I have accomplished. Is there any way to insert text also? I'd like to have the 4th cell say Rejected and turn red if any of the 3 previous cells are out of spec. To illustrate (anything over 3 is out of spec for the first cell, 4 for the 2nd, and 2 for the 3rd.) | 4 | 3 | 1 | Rejected | The 4 would throw off the entire thing. Now my only problem is that I don't know how to "conditionally insert text" as opposed to format. I'm pretty sure that excel is inflexible like this and I will have to write a macro or something, which is completely useless for the people who are going to be using this. Thank you for any advice in advance, John |
#2
|
|||
|
|||
Let's say you three conditions are in cols A,B,C and let's say that over 3 is
out of spec, then in column D: =if((A1<3)*(b1<3)*(C1<3),"","Rejected") will give you the result. -- Gary's Student "John Sawyer" wrote: Hi, I want to conditionally format a cell so that it turns red based on another's value. Actually, if any one of 3 cells are out of a specified value, then this 4th cell should turn. This much I have accomplished. Is there any way to insert text also? I'd like to have the 4th cell say Rejected and turn red if any of the 3 previous cells are out of spec. To illustrate (anything over 3 is out of spec for the first cell, 4 for the 2nd, and 2 for the 3rd.) | 4 | 3 | 1 | Rejected | The 4 would throw off the entire thing. Now my only problem is that I don't know how to "conditionally insert text" as opposed to format. I'm pretty sure that excel is inflexible like this and I will have to write a macro or something, which is completely useless for the people who are going to be using this. Thank you for any advice in advance, John |
#3
|
|||
|
|||
=IF((F14598)*(G14544)*(H14510),"","Rejected")
I get absolutely nothing from this. The reason I am using these numbers is so that I can copy it directly from the table to attempt to show what is going wrong. This is the formula directly from the table. I don't get colors or the word regardless of what I enter. Any idea? "Gary's Student" wrote: Let's say you three conditions are in cols A,B,C and let's say that over 3 is out of spec, then in column D: =if((A1<3)*(b1<3)*(C1<3),"","Rejected") will give you the result. -- Gary's Student "John Sawyer" wrote: Hi, I want to conditionally format a cell so that it turns red based on another's value. Actually, if any one of 3 cells are out of a specified value, then this 4th cell should turn. This much I have accomplished. Is there any way to insert text also? I'd like to have the 4th cell say Rejected and turn red if any of the 3 previous cells are out of spec. To illustrate (anything over 3 is out of spec for the first cell, 4 for the 2nd, and 2 for the 3rd.) | 4 | 3 | 1 | Rejected | The 4 would throw off the entire thing. Now my only problem is that I don't know how to "conditionally insert text" as opposed to format. I'm pretty sure that excel is inflexible like this and I will have to write a macro or something, which is completely useless for the people who are going to be using this. Thank you for any advice in advance, John |
#4
|
|||
|
|||
Nevermind, I think I've figured it out, and thank you for your help
"John Sawyer" wrote: =IF((F14598)*(G14544)*(H14510),"","Rejected") I get absolutely nothing from this. The reason I am using these numbers is so that I can copy it directly from the table to attempt to show what is going wrong. This is the formula directly from the table. I don't get colors or the word regardless of what I enter. Any idea? "Gary's Student" wrote: Let's say you three conditions are in cols A,B,C and let's say that over 3 is out of spec, then in column D: =if((A1<3)*(b1<3)*(C1<3),"","Rejected") will give you the result. -- Gary's Student "John Sawyer" wrote: Hi, I want to conditionally format a cell so that it turns red based on another's value. Actually, if any one of 3 cells are out of a specified value, then this 4th cell should turn. This much I have accomplished. Is there any way to insert text also? I'd like to have the 4th cell say Rejected and turn red if any of the 3 previous cells are out of spec. To illustrate (anything over 3 is out of spec for the first cell, 4 for the 2nd, and 2 for the 3rd.) | 4 | 3 | 1 | Rejected | The 4 would throw off the entire thing. Now my only problem is that I don't know how to "conditionally insert text" as opposed to format. I'm pretty sure that excel is inflexible like this and I will have to write a macro or something, which is completely useless for the people who are going to be using this. Thank you for any advice in advance, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I conditionally format in excel for >3 conditions | Excel Discussion (Misc queries) | |||
Can I conditionally format tab names in excel? | Excel Worksheet Functions | |||
2 Conditional formats and insert comment - ajit | Excel Discussion (Misc queries) | |||
conditionally format cells | Excel Worksheet Functions | |||
How do I conditionally format a chart? | Excel Discussion (Misc queries) |