Conditional formatting two cells based on a checkbox

%3CLINGO-SUB%20id%3D%22lingo-sub-2237712%22%20slang%3D%22en-US%22%3EConditional%20formatting%20two%20cells%20based%20on%20a%20checkbox%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2237712%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EI%20am%20trying%20to%20use%20a%20checked%20box%20to%20format%202%20cells%20with%20strike%20through%20text.%20I%20can't%20quite%20figure%20out%20a%20conditional%20formatting%20rule.%20Any%20ideas%3F%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2237712%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor
 

 

 
 

I am trying to use a checked box to format 2 cells with strike through text. I can't quite figure out a conditional formatting rule. Any ideas? Thanks

2 Replies

@dls5u 

Set the cell link for each check box to the cell it's in, so for example the cell link of the first check box should be C3.

This will set the value of cell C3 to TRUE or FALSE depending on the state of the check box. If you don't want to see this, apply the custom number format ;;; to the cells with the check boxes.

Select A3:B14.

On the Home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter the formula =$C3

Click Format...

On the Font tab, tick the Strikethrough check box.

Click OK, then click OK again.

Thanks, Hans! You're the Bomb!