Thread: Excel 2007: Conditional Formatting and Ribbon Data
View Single Post
  #1  
Old March 17th, 2010, 05:54 PM posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc
JJ[_2_]
external usenet poster
  
Posts: 7
Default Excel 2007: Conditional Formatting and Ribbon Data
I have several cells have conditional formatting equations which refer
to a date value in cell H1 (for example). I want to be able to move
the value stored on this cell to a control on a Ribbon.

1) Is it possible to put a Date Picker control on a Ribbon?
2) Is it possible to refer to the value of this or any other control
on a Ribbon from a Conditional Formatting equation?

Thanks!
JJ