Format text that are strikedthroughed

[Even]

Hi,

I want to format the "false" cells in column D that are striked through, however, this seems impossible without an VBA code? Does anyone know how ? For example, it would be ideal to have a white background and font for the striked through false cells in column D.

Format text that are strikethroughed.xlsx
	B	C	D
2	Active	1	TRUE
3	Active	2	FALSE
4	Inactive	2	FALSE
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:D4	Cell Value	=FALSE	text	NO
D2:D4	Cell Value	=TRUE	text	NO
D2:D4	Expression	=B2="Inactive"	text	NO

 

[Skybluekid]

Try the below:

Book1
	B
3	FALSE
4	TRUE
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:B4	Expression	=$B3=FALSE	text	NO

 

[Even]

What my table didn't show was that D4 is striked through (not sure why this doesn't show). I need the text and background in D4 to be white when the conditional formatting has it striked through.

 

[dreid1011]

What my table didn't show was that D4 is striked through (not sure why this doesn't show). I need the text and background in D4 to be white when the conditional formatting has it striked through.

You already have a CF rule to strike through the text? If you want the text and background to both be white at the same time, why not add those both to the CF rule you already have to add strike through?

 

[Even]

I can go for this solution, dreid1011 Thanks!