Conditional Formatting Rules

D

Derrick

New member

• Jan 10, 2019

• #1

Is it possible to prevent conditional formatting rules seen by end user when converted the file into exe?

 

gdgsupport

Support

Staff member

• Jan 10, 2019

• #2

Try this:

Protecting Your Conditional Formatting Rules

If you have conditional formatting applied in a worksheet, the formulas in those formats may not be as secure as you would like. This tip explains the problem and shows you what you can do to guard the formulas.

excelribbon.tips.net

 

D

Derrick

New member

• Jan 12, 2019

• #3

The link doesn’t help.
My spreadsheet required users to input the data on those cells.

 

gdgsupport

Support

Staff member

• Jan 15, 2019

• #4

We’ll try to find another way then.

 

D

Derrick

New member

• Jan 15, 2019

• #5

Thank you for looking into it.
The reason was because I have some formula in the conditional formatting too.
I have no problem with formula in the cell itself because once converted to exe file, the formula was not seen by end users. Thanks.