Conditional Format, Inserting a Word

[petiteshiraz]

Within a cell, I have the following as a conditional format rule:

=OR(B3<>"",C3<>"")

I've modified it so that if this argument is true, the color of the cell is orange.

How do I change it so that it also writes within the cell the word "OPEN" ??

 

[d_boggus]

I don't think you can input text to a cell using conditional formating however you could use a formula in the cell.

=IF(OR(B3<>"",C3<>""), "Open", "")

 

[petiteshiraz]

Nope, that did't work.

 

[CWatts]

With your conditional formatting, also set up conditional number format as well.

If you have the cell orange, also set it up so that there is a number in that cell, say 0. Then modify your conditional formatting to include a Number Format > Custom > "True"

Make sure the text is set to black (or whatever) so that when it's true, it will stand out, and when it's false, it will be 0, but it will blend in the background.

Conditional formatting will override manual formatting, so use that to your advantage.