link cell and formating not working

smm3

Board Regular
Joined
Oct 30, 2004
Messages
67
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
BCDEFGHIJKLMNOPQRSTUV
2PAPPLICATION(S) (Please keep for your records)
3 APPLICATION(S) (Please sign by red arrow and return)
4PREVIEW STATEMENT(S) (Please sign and return)
5PBIRTH CERTIFICATE ( Must be an ORIGINAL or certified copy.)
6PMEDICAL RELEASE FORMS (Sign & Date, with witness if possible)
7 ANY MEDICAL RECORDS (Send copies only if at all possible)
8PFUNCTION 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)
13PGreen Disability Report (Complete details as possible)
14 RENTAL AGREEMENT
15 OTHER:
16 W2 FOR YEARS
17PPAY STUBS FOR YOUfromthru
18 PAY STUBS FOR SPOUSE  
19 PAY STUBS FOR MOTHER  
20 PAY STUBS FOR FATHER  
21PNOTE: 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
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

chiello

Well-known Member
Joined
Jan 18, 2005
Messages
848
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

Well-known Member
Joined
Sep 18, 2004
Messages
560
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

Board Regular
Joined
Oct 30, 2004
Messages
67
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:
 

Watch MrExcel Video

Forum statistics

Threads
1,122,521
Messages
5,596,651
Members
414,083
Latest member
Mrsash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top