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

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

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

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

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

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

works a treat!!

thanks bob

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

Excellent, sorry for the original typo.

--
---
HTH

Bob


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



"Aaron Hodson (Coversure)" wrote in message
...
works a treat!!

thanks bob

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