take a look at conditional format for the range with that formula to look for the criteria you set
Assuming in your original post you meant...sorry but I don't understand your answer...
then try this.Can I add a notation where the T will show up on the monitor in Green, and the D (not T) in Black?
ADVERTISEMENT
Assuming in your original post you meant...sorry but I don't understand your answer...then try this.Can I add a notation where the T will show up on the monitor in Green, and the D (not T) in Black?
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
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.