In the "Formula is..." option in CF, you need a formula that returns a TRUE
or FALSE condition, so that a TRUE gives your conditional formatting and a
FALSE doesn't.
You had a condition =$B6=TODAY()
Why not try that in your CF "Formula is...", as Peo suggested?
--
David Biddulph
"Al Avery" wrote in message
...
I thought that "Equal to..." might be the problems as well. So I tried the
"Formula is..." option. In the formula box I entered
"=vlookup(today()+30,B6:B66)". This formula points to the correct cell
and,
therefore, produces the correct result when used in a cell by itself,
i.e.,
09/24/2008. But this procedure also changed no formatting in the range.
Stymied.
- Al AVery
"David Biddulph" wrote:
I don't have Excel 2007, but the problem is that with the "Equal to..."
option you have a used a rule equivalent to Excel 2003's "Cell Value Is",
whereas you needed "Formula Is".
I think the Excel 2007 option is labelled "Use a formula to determine
which
cells to format".
--
David Biddulph
"Al Avery" wrote in message
...
Hum, didn't work for me. Using Excel 2007 and the example above, I:
Selected F6:F66
On the Home tab, selected Condition Formatting Highlight Cell Rules
Equal to...
In the Equal to window, entered =$B6=TODAY() in the "Format cells that
are
EQUAL to" box
Chose formatting
Clicked Ok
No cell formatting in the range F6:F66 changed.
Even when I entered a specific cell in the date range,=$B$33 (in my
example), no formatting changed
Perhaps I'm doing something incorrectly.
- Al Avery
"Peo Sjoblom" wrote:
Sorry, didn't notice that the dates are in B
Select F6:F66, but use formula is
=$B6=TODAY()
--
Regards,
Peo Sjoblom
"Peo Sjoblom" wrote in message
...
Select B6:F66, with B6 as the active cell do formatconditional
formatting
select cell value is equal to
and put
=TODAY()
in the box, select the formatting you want and click OK twice
--
Regards,
Peo Sjoblom
"Al Avery" <Al wrote in message
...
My worksheet has a number of columns. The second column is a
sequence
of
month-ending dates that are one month apart. The 5th column has a
series
of
values. I want the 5th column's cell highlighted whose date in the
month-ending column includes to today's date.
Here's an example (hope it comes out clealy enough with
proportional
font):
Row Col B ... Col F
No. Month Ending ... Value
---- -------------- ---------
32 08/24/2008 45,000
33 09/24/2008 45,250
34 10/24/2008 45,500
Since today's date is 09/20/2008, cell F33 should be highlighted.
The actual array is B6:F66, without headers.
Many thanks for any help,