Conditional Formatting - strike-through cell X if cell Y contains any text?

[philipo51617]

Hi

I'm trying to add a strike-through in cell M9 if cell D9 contains any text at all.

As you can see below, cell M9 already has a formula.

Can anyone help with the conditioanl formatting please.

Cheers

 

[#2]

@philipo51617 

I only use names for formulas so it is going to look a bit different.

To determine the hourly rate, I used

= IF( hours, totalSalary/hours, "" )

[zero hours will be treated as FALSE].

The conditional formatting was based on the formula

= ISTEXT( groupName )

The format was achieved by setting Strikethrough on the Font tab.