Colour full row in CF

[craigproudfoot]

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

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

 

[Bob Phillips]

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]

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

 

[Bob Phillips]

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

--

HTH

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


"craigproudfoot"

 

[craigproudfoot]

Bob
where do i get your E-mail address from

 

[Bob Phillips]

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"

 

[Roger Govier]

Hi

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

Regards

Roger Govier

 

[Bob Phillips]

Damn! Blown my cover )

Hi

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

Regards

Roger Govier

 

[craigproudfoot]

e-mail sent