Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If no value in a1 how do I get a2 a3 a4 a5 a6 a7 a8 not to show their vaules
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If no value in a1 how do I get a2 a3 a4 a5 a6 a7 a8 not to show their vaules
One way:
Select A2:A6, with A2 active. Choose Format/Conditional Formatting... CF1: Formula = $A$1="" Format1: <font/<white/background color In article .com, "pano" wrote: 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???? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If no value in a1 how do I get a2 a3 a4 a5 a6 a7 a8 not to show their vaules
=IF(Sheet1!A1="","",Sheet1!A1)
Or =IF(Sheet1!A1=0,"",Sheet1!A1) Entered in Sheet2 A1 Gord Dibben MS Excel MVP On 10 Feb 2007 16:05:21 -0800, "pano" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If no value in a1 how do I get a2 a3 a4 a5 a6 a7 a8 not to show their vaules
On Feb 11, 11:50 am, Gord Dibben <gorddibbATshawDOTca wrote:
=IF(Sheet1!A1="","",Sheet1!A1) Or =IF(Sheet1!A1=0,"",Sheet1!A1) Entered in Sheet2 A1 Gord Dibben MS Excel MVP On 10 Feb 2007 16:05:21 -0800, "pano" wrote: 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- Hide quoted text - - Show quoted text - Thanks to you both for your replys I have gone with conditional formatting. Regards Stephen |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If no value in a1 how do I get a2 a3 a4 a5 a6 a7 a8 not to show their vaules
CF is a good method but does use up one of the 3 CF conditions for those cells.
Gord On 10 Feb 2007 17:53:14 -0800, "pano" wrote: On Feb 11, 11:50 am, Gord Dibben <gorddibbATshawDOTca wrote: =IF(Sheet1!A1="","",Sheet1!A1) Or =IF(Sheet1!A1=0,"",Sheet1!A1) Entered in Sheet2 A1 Gord Dibben MS Excel MVP On 10 Feb 2007 16:05:21 -0800, "pano" wrote: 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- Hide quoted text - - Show quoted text - Thanks to you both for your replys I have gone with conditional formatting. Regards Stephen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show last number entered | Excel Discussion (Misc queries) | |||
Show data used and percent label | Charts and Charting in Excel | |||
leading zeros are not showing in the formula bar but do show in ce | Excel Discussion (Misc queries) | |||
Show values from other sheet | Excel Worksheet Functions | |||
with formulas that show negative results I want to show zero inste | Excel Discussion (Misc queries) |