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.

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