In EXCEL,How do you control the access to SHEET2, based on a value

[Vikranth]

In EXCEL,How do you control the access to SHEET2, based on a value in SHEET1

EXAMPLE, if the value in one of the cell in sheet1 is > 80, then sheet2
should be enabled. Else, sheet2 should be disabled

[Kristin]

Hello,

I'm not sure about completely controlling access, but you could at least make sheet2 data invisible based on a value on sheet1 by using the conditional formatting feature.

Conditional formatting formulas cannot refer to other sheets. Therefore you must use a cell on sheet2 to refer to the key cell on sheet1 (=Sheet1!C1).

Once the key value is present on sheet 2, you select all of the data on sheet2, then go to the Format / Conditional Formatting command and set up conditional formatting with a formula such as: =$C$1<80.

Under format, set the font color to white.

The result is that when the value in the key cell on sheet 1 is less than 80, sheet 2 data becomes invisible. Bear in mind that the data will not print, but can still be seen/accessed by someone proficient in Excel by selecting the range, changing the formatting or viewing the data on the formula bar.