CONDITIONAL FORMATTING BETWEEN SHEETS

[CromwellP]

I'm currently working on a document that has two sheets. I have a sheet (Sheet 2) with a list of standards that I am using as validation for "Sheet 1."

What I want to happen is to apply conditional formatting that would strikethrough a cell (in Sheet 2) if I used it in Sheet 1... is this possible?

 

[Claus Busch]

Hi,

Am Wed, 3 Dec 2014 06:57:16 -0800 (PST) schrieb
(e-mail address removed):

I'm currently working on a document that has two sheets. I have a sheet (Sheet 2) with a list of standards that I am using as validation for "Sheet 1."

What I want to happen is to apply conditional formatting that would strikethrough a cell (in Sheet 2) if I used it in Sheet 1... is this possible?

give the range with the validation in Sheet1 a dynamic name. Call it
"rngValidation" and use the formula:
=OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A:$A))
Modify the formula if the range is not in column A.
Then select the range with the list in Sheet2 => Coditional Formatting
=> Formula to determine... :
=COUNTIF(rngValidation,A1)>0
and use Fonts => strikethrough as format


Regards
Claus B.