MS Excel

[Daolas]

Hi all,

A quick question, I hope....


Is is possible to do "hide" a cell if the value of that cell is equal to a particular integer?

for example

I want to hide cell A12 if the value of it is 1. If it's anything else, I want it to be visible.

I know I can manually change the color of the font to hide the cell i want, but that's a bunch of work on a worksheet that will change as much as this one.

Thanks all

 

[dave's thing]

yes it is but it is rather involved. You can go to Excel help, index Hide value (or value hide) and it will explain how to do or if you still need help PM me as I don't hang too often in the HT forum.

 

[The Greek]

You can also use the "Conditional Formatting" feature in Excel to automatically change the font settings of the cell if the value is "1". Pretty powerful formatting tool that is pretty easy to use.

 

[dave's thing]

You can also use the "Conditional Formatting" feature in Excel to automatically change the font settings of the cell if the value is "1". Pretty powerful formatting tool that is pretty easy to use.

is that under cell formatting or sheet options??

 

[The Greek]

is that under cell formatting or sheet options??

What version of Excel are you using?

For Excel 2003:
- Select the cell(s) you want to set a conditional format for
- Sect the FORMAT menu fro the menu
- Select "Conditional Formatting"
- Select the cell value options in the option boxes (for example Cell Value equal to 1)
- Select the "Format" button to set the format of the cell when the condition is true.

I believe conditonal formatting is available in Excel 2000 and the instructions may be the same

For Excel 2007, the conditional Formatting option is in the "Home" menu bar in the Styles section

 

[Daolas]

Thanks all,

I'm headed in to work now and if all goes well, I'll get a pat on the back......


LIT RULES

 

[dave's thing]

What version of Excel are you using?

For Excel 2003:
- Select the cell(s) you want to set a conditional format for
- Sect the FORMAT menu fro the menu
- Select "Conditional Formatting"
- Select the cell value options in the option boxes (for example Cell Value equal to 1)
- Select the "Format" button to set the format of the cell when the condition is true.

I believe conditonal formatting is available in Excel 2000 and the instructions may be the same

For Excel 2007, the conditional Formatting option is in the "Home" menu bar in the Styles section

Cheers........ brillaint way to do it!!

 

[The Greek]

Glad you found it useful. I use the feature quite often to do things like white out repetitive data in sorted lists, etc.

 

[dave's thing]

Thanks all,

I'm headed in to work now and if all goes well, I'll get a pat on the back......


LIT RULES

So Daolas .... how'd it go???

 

[Daolas]

How did it go?

Wonderful,

With all you guys help, I really looked like Johnny on the Spot with my new excel spreadsheet.


Thanks again,

Dao

 

[RawHumor]

If you want it to literally be invisible, you can do it with number formatting.
Right-click the cell, click Format. Click Custom and type in the following format: [=1]"";General.

What that means is that, if the number is 1, then nothing will be displayed (""). Otherwise, it will be General format.