Conditional formatting strangeness

[duncan79]

i've applied a conditional formatting formula to a range of cells, when the condition is true the formatting only occurs in the top left cell of the area

anybody know why???

[Bob Umlas, Excel MVP]

You've most likely misused a relative/absolute address. Check the conditional
format of ONE of the cells which is not working and you'll probably see the
error.

"duncan79" wrote:

>
> i've applied a conditional formatting formula to a range of cells, when
> the condition is true the formatting only occurs in the top left cell
> of the area
>
> anybody know why???
>
>
> --
> duncan79
> ------------------------------------------------------------------------
> duncan79's Profile: http://www.excelforum.com/member.php...o&userid=30833
> View this thread: http://www.excelforum.com/showthread...hreadid=542935
>
>

[duncan79]

AHHHH of course i didnt even think of that thanks

[Bernard Liengme]

Tell us what formula you have used. Do it have absolute referencing such as
$B$3 ?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"duncan79" <[email protected]> wrote in
message news:[email protected]...
>
> i've applied a conditional formatting formula to a range of cells, when
> the condition is true the formatting only occurs in the top left cell
> of the area
>
> anybody know why???
>
>
> --
> duncan79
> ------------------------------------------------------------------------
> duncan79's Profile:
> http://www.excelforum.com/member.php...o&userid=30833
> View this thread: http://www.excelforum.com/showthread...hreadid=542935
>

[Bob Umlas, Excel MVP]

"Do it have..."??? Ha ha - must be Nova Scotia lingo! :-)
Hey, Bernard, - how's things?

"Bernard Liengme" wrote:

> Tell us what formula you have used. Do it have absolute referencing such as
> $B$3 ?
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "duncan79" <[email protected]> wrote in
> message news:[email protected]...
> >
> > i've applied a conditional formatting formula to a range of cells, when
> > the condition is true the formatting only occurs in the top left cell
> > of the area
> >
> > anybody know why???
> >
> >
> > --
> > duncan79
> > ------------------------------------------------------------------------
> > duncan79's Profile:
> > http://www.excelforum.com/member.php...o&userid=30833
> > View this thread: http://www.excelforum.com/showthread...hreadid=542935
> >
>
>
>

[Bernard Liengme]

Well spotted!
--
Bernard
"Bob Umlas, Excel MVP" <[email protected]> wrote in
message news:[email protected]...
> "Do it have..."??? Ha ha - must be Nova Scotia lingo! :-)
> Hey, Bernard, - how's things?
>
> "Bernard Liengme" wrote:
>
>> Tell us what formula you have used. Do it have absolute referencing such
>> as
>> $B$3 ?
>> --
>> Bernard V Liengme
>> www.stfx.ca/people/bliengme
>> remove caps from email
>>
>> "duncan79" <[email protected]> wrote
>> in
>> message news:[email protected]...
>> >
>> > i've applied a conditional formatting formula to a range of cells, when
>> > the condition is true the formatting only occurs in the top left cell
>> > of the area
>> >
>> > anybody know why???
>> >
>> >
>> > --
>> > duncan79
>> > ------------------------------------------------------------------------
>> > duncan79's Profile:
>> > http://www.excelforum.com/member.php...o&userid=30833
>> > View this thread:
>> > http://www.excelforum.com/showthread...hreadid=542935
>> >
>>
>>
>>