Forum Discussion
Conditional Formatting - strike-through cell X if cell Y contains any text?
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 ple...
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.