CONDITIONAL FORMATTING BETWEEN SHEETS

  • Thread starter Thread starter CromwellP
  • Start date Start date
C

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?
 
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?
Click to expand...

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.
 
Back
Top