another conditional format

[Wzbell]

I want to bold the text in one cell if there is any text in another cell. Any ideas?

Also what if the 2nd cell is blank? is the away to do that also? These won't be used together of course.

[BigBas]

What you want to do is possible, but you need to be more specific. Which cells are being compared?

[Wzbell]

What you want to do is possible, but you need to be more specific. Which cells are being compared?

For example I want to bold the text in B12 if cell s12 is blank.

[BigBas]

Click on B12>format>conditional formats>click the drop down box that says "cell value is" and replace it with "formula is">enter formula =S12="">click format, and choose bold.

That should do it.

Let me know if you have any further questions.

[teelim]

I think this is what you are looking for...

[Wzbell]

For example I want to bold the text in B12 if cell s12 is blank.

Worked fine but I see I need something else. What do I need to add if I want it to only bold if there is a value in A12?

[BigBas]

Use this formula for the conditional format:

=AND(S12="",A12<>"")