Just a sugestion.... Its better to work the oposit direction. You should put a formula into the cells that set it´s number to 1 or 0, then use conditional format based on the cells values...
The conditional format can´t change the cells value. 2009/6/14 Raja <[email protected]> > i have a excel worksheet 2007 with conditional format (see attached). i > want to make the cell value 0 (zero) in the blank area and it should turn to > 1 (one) when there is a format. (format changes when you change dates) can > any one help me with it. > > Thanks......Raja > > > > > > > > -- Fabio Lemos e-mail: [email protected] --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] or Ashish Jain @ [email protected] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
