conditional formatting

[raymondsum]

Hi,

When i input value in A1 eg 100,
then in B1 i set a formula =if(A1>99,today(),""),
in B1, it returns to 4/12/2003

but i want to set this formula in B1
Format>Conditional Formatting>Formual Is> =if(A1>99,today(),""),
it returns nothing, blank cell

why? if the conditional formatting cannot satisfy my request. please
suggest me another method or VB.

thanks in advance.

Raymond

 

[Paul]

Hi,

When i input value in A1 eg 100,
then in B1 i set a formula =if(A1>99,today(),""),
in B1, it returns to 4/12/2003

but i want to set this formula in B1
Format>Conditional Formatting>Formual Is> =if(A1>99,today(),""),
it returns nothing, blank cell

why? if the conditional formatting cannot satisfy my request. please
suggest me another method or VB.

thanks in advance.

Raymond

You use a normal formula in a cell to return a VALUE to that cell.
You use a formula in conditional formatting to set the FORMAT of the cell
(not the value in it).
These are two separate things.

The formula in conditional formatting must be one that evaluates true/false.
The result merely decides whether or not to apply the specified formatting.
So you could have the conditional formatting formula for B1
=(A1>99)
but the formula you quote
=if(A1>99,today(),"")
can only be used in the worksheet itself.

 

[Jim]

It looks as if your date setting is dd/mm/yyyy instead of the US mm/dd/yyyy.

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays

Hi,

When i input value in A1 eg 100,
then in B1 i set a formula =if(A1>99,today(),""),
in B1, it returns to 4/12/2003

but i want to set this formula in B1
Format>Conditional Formatting>Formual Is> =if(A1>99,today(),""),
it returns nothing, blank cell

why? if the conditional formatting cannot satisfy my request. please
suggest me another method or VB.

thanks in advance.

Raymond


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements