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.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies