Formula Question

[ironsides]

This formula works well. Can I add a notation where the T will show up on the monitor in Green, and the T in Black?


=IF(OR(P4={"AT","BT","SM","BI","SI"}),"T","D")

Thank you

 

[texasalynn]

take a look at conditional format for the range with that formula to look for the criteria you set

 

[ironsides]

take a look at conditional format for the range with that formula to look for the criteria you set

...sorry but I don't understand your answer...

 

[Peter_SSs]

...sorry but I don't understand your answer...

Assuming in your original post you meant

Can I add a notation where the T will show up on the monitor in Green, and the D (not T) in Black?

then try this.

1. Select the cell that contains the formula =IF(OR(P4={"AT","BT","SM","BI","SI"}),"T","D")
2. From the menus choose Format|Conditional Formatting...|Condition 1|Cell Value Is|equal to|="T"|Format...|Font|Colour: choose green|OK|Add>>|Condition 2|Cell Value Is|equal to|="D"|Format...|Font|Colour: choose black|OK|OK

 

[ironsides]

...sorry but I don't understand your answer...

Assuming in your original post you meant

Can I add a notation where the T will show up on the monitor in Green, and the D (not T) in Black?

then try this.

1. Select the cell that contains the formula =IF(OR(P4={"AT","BT","SM","BI","SI"}),"T","D")
2. From the menus choose Format|Conditional Formatting...|Condition 1|Cell Value Is|equal to|="T"|Format...|Font|Colour: choose green|OK|Add>>|Condition 2|Cell Value Is|equal to|="D"|Format...|Font|Colour: choose black|OK|OK

Thank you Peter. Worked fine exactly as you said. Matt

 

[Peter_SSs]

ironsides

Just re-visiting this thread I wondered why I put Condition 2 in the Conditional Formatting.
If you are using the standard black for your fonts in this sheet, then there is no need for Condition 2.

You could select the cell or range of cells that contain this Conditional Formatting and then Format|Conditional Formatting...|Delete...|Tick Condition 2|OK|OK. "T" will still show up green and "D" will show up black.

If your Conditional Formatting is only in a small number of cells it will not matter much either way, but if it covers a LOT of cells then the additional condition may start to slow your sheet.

 

[ironsides]

ironsides

Just re-visiting this thread I wondered why I put Condition 2 in the Conditional Formatting.
If you are using the standard black for your fonts in this sheet, then there is no need for Condition 2.

You could select the cell or range of cells that contain this Conditional Formatting and then Format|Conditional Formatting...|Delete...|Tick Condition 2|OK|OK. "T" will still show up green and "D" will show up black.

If your Conditional Formatting is only in a small number of cells it will not matter much either way, but if it covers a LOT of cells then the additional condition may start to slow your sheet.

Actually Peter, it worked the way you specified because I mistakenly used Black in my example when it should have been Brown. So all is well. Thanks for following up. Matt