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

New Contributor



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.



 conditional formatting.PNG


1 Reply


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.