You're welcome!
> Any chance you have a 'cheat sheet' for formulas handy or know where i can
> find one?
Maybe this:
http://homepage.ntlworld.com/noneley/
I do something similar except I keep a library of formulas in separate files
and I tend to only "catalogue" the really complex formulas. Right now I have
349 sample files and each file contains dozens of formula variations.
One of these days I'd like to compile all these formulas into a book or do
something similar to what Peter did.
--
Biff
Microsoft Excel MVP
"FIRE GIRL" <(E-Mail Removed)> wrote in message
news:5CCBE287-EA62-4658-A0F1-(E-Mail Removed)...
> THAT WORKED!!!
> THANK YOU!
>
>
> Any chance you have a 'cheat sheet' for formulas handy or know where i can
> find one? :-)
>
> "T. Valko" wrote:
>
>> If I understand, change the formula to:
>>
>> =A2<=$G$5
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "FIRE GIRL" <(E-Mail Removed)> wrote in message
>> news:160DFBB3-31BE-46FC-860F-(E-Mail Removed)...
>> > Okay, that worked! but my next problem... it is only applying the
>> > formula
>> > if
>> > the dates are EXACTLY the same... can i make it so if it is today or
>> > any
>> > day
>> > AFTER today it will continue the formatting??
>> >
>> > "T. Valko" wrote:
>> >
>> >> Try this:
>> >>
>> >> Select cell A2
>> >> Goto the menu Format>Conditional Formatting
>> >> Select the Formula Is option
>> >> Enter this formula in the little box on the right:
>> >>
>> >> =A2=$G$5
>> >>
>> >> Click the Format button
>> >> Select the desired style(s)
>> >> OK out
>> >>
>> >> --
>> >> Biff
>> >> Microsoft Excel MVP
>> >>
>> >>
>> >> "FIRE GIRL" <(E-Mail Removed)> wrote in message
>> >> news:8165BF0C-A247-4A09-A570-(E-Mail Removed)...
>> >> > I'm trying to apply conditional formatting to a cell, to show it has
>> >> > expired
>> >> > when today's date equals the date of expiration.
>> >> >
>> >> > I have the =today() formula in a cell for reference, however
>> >> > the
>> >> > conditional formatting changes immediately even though the two cells
>> >> > are
>> >> > not
>> >> > equal..
>> >> >
>> >> > What am i doing wrong??
>> >> > example:
>> >> >
>> >> > cell A2 is the date of expiration- 7-1-2012
>> >> > cell G5 is today's date- 8-15-2008
>> >> >
>> >> > when they are equal to each other, the conditional formatting should
>> >> > apply.
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>
Similar Threads
