Condtional Format with a Word and Fill Color

[Legacy 436357]

Hi,

I have these formulas in cell B3 for conditional formatting:

=L3="Yes" (I set the fill color to red)
=L3="No" (I set the fill color to green)

How can I add the word "Closed" if yes and "Open" if no in conditional formatting?

Thank you

 

[Special-K99]

This is nothing to do with conditional formatting. Conditional formatting changes the format not the value.
You are changing the value.

Just put a formula in the cell you want (which for some reason you've omitted) to set the value, e.g.

in A1
=IF(L3="Yes","Closed","Open")

 

[Legacy 436357]

I need a break from the screen omg. That is so obvious thank you.