Cells that conditionally appearq

  • Thread starter Thread starter Jason
  • Start date Start date
J

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
 
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","")
 
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
 
Back
Top