Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Using validation to make data appear or not



I have an array of cells that all rely on a "Y" or "N" value in another
cell, and an IF statement to either make the data appear or not appear.

It works fine, except that when the data appears and fill, the borders
pop up fine. Some of them, however refuse to disappear the same way the
data does, yet others do just fine. This includes cell color formatting,
which I am able to make stay or go. I just seem to have a problem with
some cell retaining persistent border, which go away completely if I
remove them, but that isn't what I want. I want them to behave just like
the cells do where the border does disappear along with the data. I just
cannot figure out why I have some picky cell formats, and cannot figure
out what to do to kill it.

I know this isn't a function, but it is the product of one.

My disappear code is like: IF(C5="Y",H5,"")
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation - Temporarily Make dropdown list wider Alison Excel Discussion (Misc queries) 1 February 14th 08 12:13 PM
How do I make a Validation List in Excel, using data on a second Driver Excel Discussion (Misc queries) 2 February 23rd 06 01:30 PM
HOW DO I MAKE VALIDATION LIST CONTAING DATA FROM A DIFFERENT BO CHAIM Excel Discussion (Misc queries) 1 September 29th 05 08:28 PM
Data Validation - Drop-down list - make arrow visible at all times supergoat Excel Discussion (Misc queries) 3 April 19th 05 01:01 PM
Make Data validation List Alphabetical?? Slumbering Gorilla Excel Worksheet Functions 6 November 19th 04 09:49 PM


All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"