View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
adamcr64 adamcr64 is offline
external usenet poster
 
Posts: 4
Default formula to hide a row in excel 2007

This is for a customer incoming order. there are several hundred items and as
a value is added to a item it causes to item information line to unhide. C6
is one of the hundreds that need to be done

"Mike H" wrote:

Hi,

You can't do that with a formula, it would have to be a macro. Tell us about
C6, is it a value that you enter or a formula?
--
Mike

When competing hypotheses are equal, adopt the hypothesis that introduces
the fewest assumptions while still sufficiently answering the question.
Occam''s razor (Abbrev)


"adamcr64" wrote:

what is the formula to unhide row 27 if the value of cell C6 is greater than 0?