link cell and formating not working

[smm3]

It's official, I’m lost!!

I have a worksheet(checklist) that links to (copylist). I’ve tried to conditional format copylist b2:b21 so if the cell is blank, the text in the cell to the right will not be visible or print. IT’S NOT WORKING!

When I double click on checklist b8, it puts “P” which becomes a checkmark. A checkmark also appears on copylist b2. Nothing happens after that.

Below is a part of copylist sheet.

Any and all help is so greatly appreciated!!!

Vickie

XInterviewX.xls
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
2	P	APPLICATION(S) (Please keep for your records)
3		APPLICATION(S) (Please sign by red arrow and return)
4	P	REVIEW STATEMENT(S) (Please sign and return)
5	P	BIRTH CERTIFICATE ( Must be an ORIGINAL or certified copy.)
6	P	MEDICAL RELEASE FORMS (Sign & Date, with witness if possible)
7		ANY MEDICAL RECORDS (Send copies only if at all possible)
8	P	FUNCTION REPORT (Complete in as much detail as possible)
9		WORK ACTIVITY REPORT (Complete in as much detail as possible)
10		VOIDED CHECK (For direct deposit)
11		MILITARY DISCHARGE PAPERS (example: DD214)
12		Blue Disability Report (Complete details as possible)
13	P	Green Disability Report (Complete details as possible)
14		RENTAL AGREEMENT
15		OTHER:
16		W2 FOR YEARS
17	P	PAY STUBS FOR YOU								from				thru
18		PAY STUBS FOR SPOUSE
19		PAY STUBS FOR MOTHER
20		PAY STUBS FOR FATHER
21	P	NOTE: Please make sure ALL pay stubs are present for the time requested. Verifying wages without ALL the pay stubs will not be possible. A printout from the employer showing gross earnings for EACH MONTH can be substituted for pay stubs.
22
23
copylist

 

[chiello]

Why don't you insert
in B2: "=IF(A2="P","APPLICATION(S) (Please keep for your records)","")
in B3: "=IF(A3="P","APPLICATION(S) (Please sign by red arrow and return)","")
and so on ...

 

[Dutchy]

Your "applications...etc" text is in Column C right?

To hide with conditional formatting highlight C1 down as far as you need and conditional format with

Formula is

=B1=""

select white font

This will ensure that cells in column C appear to be blank if B is blank

 

[smm3]

Love and hate

Okay, I love and hate you guys at the same time.

Both of your suggestions work!
My problem is you both did it so fast and made it look so easy.
I spent hours looking thur this site and trying to make it work on my own!!!!!

On the love side, Thanks so much for your help. I would have spent so much more time trying to make this work. Thanks doesn't seem like much.

I really appreciate your help.

Vickie

:wink: