Cells that conditionally appearq

[Jason]

I am looking to have cells appear based on other cells or
button responses. I have used a spreadsheet before that
allowed cells to appear based on information located in
other cells. How do I do this? Thanks

 

[Frank Kabel]

Hi Jason
what do you mean with 'appear'. If you just want to test another cell
for an antry you may try the following
=IF(A1="entry","entry in target cell","")

 

[Chip Pearson]

Jason,

I think you are referring to Conditional Formatting from the
Format menu. In that dialog, change "Cell Value Is" to "Formula
Is" and enter a formula referring to the cells in question and
click the Format button to select a format. If the formula
returns TRUE or a non-zero numeric result, the format will be
applied. If the formula returns FALSE or a zero, the format will
be applied.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com