Home

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

philipo51617
New Contributor

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

 

 conditional formatting.PNG

 

1 Reply

@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.