That was what I needed
Thankyou very much

"David Biddulph" wrote:

Well, you haven't told us what condition you are using for your conditional
formatting, and you haven't told us what the formula in the cell is doing,
so you are relying on contributors to the group using a lot of guess-work or
extra-sensory perception. Would like to give us a few clues to narrow
things down a bit?

If, by any chance, you have a formula that is returning an empty string "",
and your CF is merely looking for A10, you could change the latter to
Formula Is =AND(A1<"",A10)
--
David Biddulph

"Dreamstar_1961" wrote in message
...
that was office 2007 not the year 2007, all changed with this version

"Bob Phillips" wrote:

The grouping facility has a Years option just as it has a Months option.

"Dreamstar_1961" wrote in
message
...
Been trying to get a condition formating to work, using 2007, trying to
get
the cell to turn red if greater than 0 the problem is that there is a
formula
in this cell that means the cell thinks it's greater than 0 so always
is
red,
how do I fix this problem.

thanks