Simple Conditional Formating Help Required - If Blank then Red Bold text required

Hello Friends



My Requirement is simple. By using Conditional Formatting if the Cell L20 is blank then the text in the Cell N20 should be red (And bold if possible).

The N20 cell carries a formula.

thanks

thilag

Do you mean L20 is empty, or contains the word "blank" as in your example?

Pete

L20 is emply, the word blank is used just for illustration

thilag

Then AlKey has given you the solution.

Pete

Hello Alkey

it is not working. I do know what is the rror.

thanks

thilag

Hello AlKey

It works fine, thanks, sorry earlier i misunderstood,

thanks

thilag