conditional formatting - repeat formula

[Aaron Hodson \(Coversure\)]

Hello,

I am trying to perform a basic (!!) task which involves a table where the
lowest figure requires to be highlighted.

I used the formula in conditional formatting "cell value" "equals"
"min$F$3:$H$3"

This works fine, but, my table has already been created and i want to
continue this to row 50.

How can I do this without having to conditional format every 3 cells??

I am using both xp & 07 office (if this helps)

Thanks

Aaron

 

[Bob Phillips]

Select the cells, I assume starting at A1, and use a formula of

=AND(A1=MIN($F3:$H3),MOD(ROW(A1),3)=0)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Aaron Hodson \(Coversure\)]

Cannot get this to work...

To explain in a little more detail, my table ranged from A1 to O50.

Data from F3:H3 to F50:H50 is required for formatting.

I need the lowest figure being highlighted out of F3,G3,H3
Then again out of F4,G4,H4
etc down to row 50.

Thanks

Aaron

 

[Bob Phillips]

That works fine for me with that range.

Select A1:O50 and apply the CF.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Aaron Hodson \(Coversure\)]

Sorry,
still can't get this working....
Can i send it across to you?
is it maybe becuae i am working in office 2007 compat mode?

 

[Bob Phillips]

I had an error in the formula, it should have been

=AND(A1=MIN($F1:$H1),MOD(ROW(A1),3)=0)

but this works just as well in 2007 compatibility mode.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Aaron Hodson \(Coversure\)]

works a treat!!

thanks bob

I had an error in the formula, it should have been

=AND(A1=MIN($F1:$H1),MOD(ROW(A1),3)=0)

but this works just as well in 2007 compatibility mode.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)

 

[Bob Phillips]

Excellent, sorry for the original typo.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)