Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If statement for text
I have a conditional format in cell d18. If d18=green, then the text is
green. If d18=red, then text is red. I want to have the same kind of formula for the E cells. Something like: If d18=green, then c18 characters is green. If d18=red, then c18 characters is red. |
#2
|
|||
|
|||
Use a formula of =$D18="green"
-- HTH RP (remove nothere from the email address if mailing direct) "decanno04" wrote in message ... I have a conditional format in cell d18. If d18=green, then the text is green. If d18=red, then text is red. I want to have the same kind of formula for the E cells. Something like: If d18=green, then c18 characters is green. If d18=red, then c18 characters is red. |
#3
|
|||
|
|||
Assuming the "E cells" was a type-o, this procedure will Conditionally
Format C18 Select C18, then do Format ConditionalFormatting and Condition 1 settings as follows Formula Is =D18="green" then press the Format button and select the Font tab and choose GREEN color OK Then click the Add button and Condition 2 settings as follows Formula Is =D18="Red" then press the Format button and select the Font tab and choose RED color OK Vaya cn Dios, Chuck, CABGx3 "decanno04" wrote in message ... I have a conditional format in cell d18. If d18=green, then the text is green. If d18=red, then text is red. I want to have the same kind of formula for the E cells. Something like: If d18=green, then c18 characters is green. If d18=red, then c18 characters is red. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
IF Statement | New Users to Excel | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
7+ nested if statement? | Excel Worksheet Functions | |||
Statement | Excel Worksheet Functions |