If no value in a1 how do I get a2 a3 a4 a5 a6 a7 a8 not to show their vaules

  • Thread starter Thread starter pano
  • Start date Start date
P

pano

Hi all,

How do I do this, A1 sheet2 has a date in it linked from sheet1 __ A2
A3 A4 A5 A6 also have links in it from sheet1. I want to be able to if
the date does not appear in A1 that the other cells do not show up as
well or format white or whatever trick anyone knows????


Thanks
Stephen
 
One way:
Select A2:A6, with A2 active. Choose Format/Conditional Formatting...

CF1: Formula = $A$1=""
Format1: <font>/<white/background color>
 
=IF(Sheet1!A1="","",Sheet1!A1)

Or =IF(Sheet1!A1=0,"",Sheet1!A1)

Entered in Sheet2 A1


Gord Dibben MS Excel MVP
 
=IF(Sheet1!A1="","",Sheet1!A1)

Or =IF(Sheet1!A1=0,"",Sheet1!A1)

Entered in Sheet2 A1

Gord Dibben MS Excel MVP





- Show quoted text -
Click to expand...

Thanks to you both for your replys I have gone with conditional
formatting.
Regards
Stephen
 
CF is a good method but does use up one of the 3 CF conditions for those cells.


Gord
 
Back
Top