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

%3CLINGO-SUB%20id%3D%22lingo-sub-375852%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20-%20strike-through%20cell%20X%20if%20cell%20Y%20contains%20any%20text%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-375852%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20add%20a%20strike-through%20in%20cell%20M9%20if%20cell%20D9%20contains%20any%20text%20at%20all.%3C%2FP%3E%3CP%3EAs%20you%20can%20see%20below%2C%20cell%20M9%20already%20has%20a%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20with%20the%20conditioanl%20formatting%20please.%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22conditional%20formatting.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F93475iA3A935426B7BDE04%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22conditional%20formatting.PNG%22%20alt%3D%22conditional%20formatting.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-375852%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-375863%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20-%20strike-through%20cell%20X%20if%20cell%20Y%20contains%20any%20text%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-375863%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F287970%22%20target%3D%22_blank%22%3E%40philipo51617%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20only%20use%20names%20for%20formulas%20so%20it%20is%20going%20to%20look%20a%20bit%20different.%3C%2FP%3E%3CP%3ETo%20determine%20the%20hourly%20rate%2C%20I%20used%3C%2FP%3E%3CP%3E%3D%20IF(%20hours%2C%20totalSalary%2Fhours%2C%20%22%22%20)%3C%2FP%3E%3CP%3E%5Bzero%20hours%20will%20be%20treated%20as%20FALSE%5D.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20conditional%20formatting%20was%20based%20on%20the%20formula%3C%2FP%3E%3CP%3E%3D%20ISTEXT(%20groupName%20)%3C%2FP%3E%3CP%3EThe%20format%20was%20achieved%20by%20setting%20Strikethrough%20on%20the%20Font%20tab.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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
Highlighted

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