Formatting & Printing

[Ben]

Hi,

I have two Questions.

1) How do you set the formating of certain cells change
based upon what is in there. For example if I have a
range of data A3:F45 each cell has a similiar formula
where data only appears if it meets the criteria..@if
(A1="","",b4-F5+H1). How do you make it so that the
Formatting changes, based upon if the formula is false or
the second option. Specfically the Gridlines around the
cell appearing if there is data instead of "".

2) In the above example is there a way, other than
manually, to print only the section that shows data even
though there are many other cell that have formula's and
are set to "" ?

Thanks for your time.

ben

 

[Jim Rech]

The display or printing of gridlines is a worksheet setting, one that
applies to the entire sheet and not to specific cells. Cell borders, otoh,
is something that can be set individually for specific cells, so maybe
that's what you want to vary.

You cannot change cell borders via formula but you might want to look at
Conditional Formatting on the Format menu. For example, if you wanted a
non-blank cell to have a border you'd select "formula is" in the dropdown
and enter =LEN(A1)>0 as the condition (substituting the active cell for A1).
Then select the format to be used when the condition is met. Cell border is
one of the formatting option you can set.

 

[BrianB]

Have a look at Format/Conditional Formattin

 

[Guest]

Thanks!

 

[Guest]

Thanks1