Making text invisible using conditional formatting

[Darren_workforce]

Hello,

I am struggling with the formula needed to cause any cell with "off" to turn the text invisible. I've attempted

=$A$2="off"

and I've tried using the custom number formatting (;; but it isn't working.

This is for the entire sheet but Row 1 is not required as the data is setup in a table

Any help would be appreciated.

 

[etaf]

using conditional formatting and change the font colour and change to the same colour as the background - that will look invisible - BUT will still have the value in the cell

 

[Fluff]

Try using

=A2="off"

 

[Darren_workforce]

have you change font and change to the same colour as the background - that will look invisible - BUT will still have the value in the cell

I wanted to try that. Unfortunately it's a table linked from another worksheet. The colors alternate

Try using

=A2="off"

Apparently that was all that was needed. Thank you Fluff!

 

[Darren_workforce]

using conditional formatting and change the font colour and change to the same colour as the background - that will look invisible - BUT will still have the value in the cell

I wanted to try that but it's setup as a table and is data shared from another worksheet so I didn't want to remove the table in the event that screws up the data connection. But since the table is multi-colored, it would require multiple formulas to achieve. Thanks for the suggestion, though!!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[etaf]

you have as solved - but then mentioned condition formatting did not work because of a table

so is it fixed removing the $$ ?

try formatting with 3 ; (semicolons)
;;;

which i have done on this TABLE

Book5
	F
1	Column6
2	date
3
4
5
6
7
Sheet2

 

[Darren_workforce]

you have as solved - but then mentioned condition formatting did not work because of a table

so is it fixed removing the $$ ?

try formatting with 3 ; (semicolons)
;;;

which i have done on this TABLE

Book5
	F
1	Column6
2	date
3
4
5
6
7
Sheet2

Good day!

Yes, apologies. I had the formatting setup with ;;; but was struggling with the formula itself. One the formula was tweaked, it worked alongside the text formatting and hid everything.

My leadership team reviewed the file and were concerned that the information still "existed" while invisible and could be accessed by anyone on the team. So that was all for nothing. I need to try and figure out how to setup a VBA macro to completely delete specific pieces of information when the file is opened.