Colour full row in CF
 

The following formula colours the lowest value cell in a list (even when
filtered) How can i make the formatting cover the full row? My formula
is as follows:

cell value is equal to =SUBTOTAL(5,$F:$F)


--
craigproudfoot
------------------------------------------------------------------------
craigproudfoot's Profile: http://www.excelforum.com/member.php...o&userid=28709
View this thread: http://www.excelforum.com/showthread...hreadid=484216

Colour full row in CF
 

Select the whole row and apply that formula to CF after having done that.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"craigproudfoot"
<craigproudfoot.1ybrun_1131700208.8013@excelforu m-nospam.com wrote in
message news:craigproudfoot.1ybrun_1131700208.8013@excelfo rum-nospam.com...

The following formula colours the lowest value cell in a list (even when
filtered) How can i make the formatting cover the full row? My formula
is as follows:

cell value is equal to =SUBTOTAL(5,$F:$F)


--
craigproudfoot
------------------------------------------------------------------------
craigproudfoot's Profile:
http://www.excelforum.com/member.php...o&userid=28709
View this thread: http://www.excelforum.com/showthread...hreadid=484216

Colour full row in CF
 

not sure i follow, could i send you a cut down version of the
spreadsheet for you to look at?


--
craigproudfoot
------------------------------------------------------------------------
craigproudfoot's Profile: http://www.excelforum.com/member.php...o&userid=28709
View this thread: http://www.excelforum.com/showthread...hreadid=484216

Colour full row in CF
 

Yeah, go ahead, but put Excel in the title.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"craigproudfoot"
<craigproudfoot.1ybumm_1131703826.3783@excelforu m-nospam.com wrote in
message news:craigproudfoot.1ybumm_1131703826.3783@excelfo rum-nospam.com...

not sure i follow, could i send you a cut down version of the
spreadsheet for you to look at?


--
craigproudfoot
------------------------------------------------------------------------
craigproudfoot's Profile:
http://www.excelforum.com/member.php...o&userid=28709
View this thread: http://www.excelforum.com/showthread...hreadid=484216

Colour full row in CF
 

Bob
where do i get your E-mail address from


--
craigproudfoot
------------------------------------------------------------------------
craigproudfoot's Profile: http://www.excelforum.com/member.php...o&userid=28709
View this thread: http://www.excelforum.com/showthread...hreadid=484216

Colour full row in CF
 

It is

bob dot phillips at tiscal dot co dot uk

do the obvious

--

HTH

RP
(remove nothere from the email address if mailing direct)


"craigproudfoot"
<craigproudfoot.1ybz9c_1131709803.0547@excelforu m-nospam.com wrote in
message news:craigproudfoot.1ybz9c_1131709803.0547@excelfo rum-nospam.com...

Bob
where do i get your E-mail address from


--
craigproudfoot
------------------------------------------------------------------------
craigproudfoot's Profile:
http://www.excelforum.com/member.php...o&userid=28709
View this thread: http://www.excelforum.com/showthread...hreadid=484216

Colour full row in CF
 

Hi

I think that Bob meant tiscali not tiscal in the address.

Regards

Roger Govier


Bob Phillips wrote:
It is

bob dot phillips at tiscal dot co dot uk

do the obvious

Colour full row in CF
 

Damn! Blown my cover :-))


"Roger Govier" wrote in message
...
Hi

I think that Bob meant tiscali not tiscal in the address.

Regards

Roger Govier


Bob Phillips wrote:
It is

bob dot phillips at tiscal dot co dot uk

do the obvious

Colour full row in CF
 

e-mail sent


--
craigproudfoot
------------------------------------------------------------------------
craigproudfoot's Profile: http://www.excelforum.com/member.php...o&userid=28709
View this thread: http://www.excelforum.com/showthread...hreadid=484216