LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 440
Default CF to grey out the two unused options

The user has the option of entering a date in either of cells Y,Z or AA on
any given row. If Z is picked, for example, I would like the 2 unused cells
on the same row to be greyed out. If the date is then removed and put in AA,
then the CF would grey out the other 2 unused cells.
--
Traa Dy Liooar

Jock
 
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
Excel 2002 options grey out Gary B[_2_] Excel Discussion (Misc queries) 2 September 6th 08 02:41 PM
trying to draw a text box, but options are grey bbatman Excel Discussion (Misc queries) 1 November 28th 07 09:36 PM
grey out insert menu options gemini3rdeye Excel Worksheet Functions 7 October 12th 07 09:48 PM
what to do with unused cells B Excel Worksheet Functions 1 June 22nd 06 12:09 AM
delete unused columns and grey out the rest area random number generator Excel Worksheet Functions 1 March 31st 06 06:32 PM


All times are GMT +1. The time now is 06:05 AM.

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"