Conditional formatting strangeness
 

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

Conditional formatting strangeness
 

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

Conditional formatting strangeness
 

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" wrote in
message ...

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

Conditional formatting strangeness
 

AHHHH of course i didnt even think of that thanks


--
duncan79
------------------------------------------------------------------------
duncan79's Profile: http://www.excelforum.com/member.php...o&userid=30833
View this thread: http://www.excelforum.com/showthread...hreadid=542935

Conditional formatting strangeness
 

"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" wrote in
message ...

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

Conditional formatting strangeness
 

Well spotted!
--
Bernard
"Bob Umlas, Excel MVP" wrote in
message ...
"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" wrote
in
message ...

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