View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default conditionally hiding rows

Functions and formulas return values. They do not hide rows or such. The
closest you get is conditional formatting which changes the format of a cell
but it can not hide rows. Filtering hides rows but it is not automatic as I
suspect that you want. The only thing left is macros which can work if you
want to go there...
--
HTH...

Jim Thomlinson


"Derrick" wrote:

can anyone help me figure out this problem?
I have an drop down option list, and i would like to create an if statement
that will hide select rows depending on which option is selected:
ie if option A is checked,
then rows 23,24, 26 are hidden.
if option b is checked,
rows 25, 27,28 are hidden
and if option c is checked
rows 21 22 29 are hidden.
simple enough i hope?

thanks!