Looking along a row to find specific values
 

I posted this question a few days ago but didn't really get anything I could
use, so in an attempt to phrase my question better, here goes:

I have a spreadsheet in to which users enter measurements. Each row is for
an individual asset, however, there are 8 readings entered on the row for
measurements along a particular asset. The columns are not sequential either!

I need a method which will:

1. Tell me of any values greater than or equal to 1439, but less than or
equal to 1449
2. Tell me of any values greater than or equal to 1450
3. Tell me of any values less than 1439.

I had thought conditional formatting would be the way ahead but I can't work
out how to get Excel to look along the row, rather than in just one cell.

Your help and patience is greatly appreciated.

Phil

Looking along a row to find specific values
 

Which columns are used for your 8 readings?

How many rows of data do you have?

What colours do you want for your 3 conditions?

Pete



On Feb 9, 12:04*pm, PhillyD wrote:
I posted this question a few days ago but didn't really get anything I could
use, so in an attempt to phrase my question better, here goes:

I have a spreadsheet in to which users enter measurements. Each row is for
an individual asset, however, there are 8 readings entered on the row for
measurements along a particular asset. The columns are not sequential either!

I need a method which will:

1. Tell me of any values greater than or equal to 1439, but less than or
equal to 1449
2. Tell me of any values greater than or equal to 1450
3. Tell me of any values less than 1439.

I had thought conditional formatting would be the way ahead but I can't work
out how to get Excel to look along the row, rather than in just one cell.

Your help and patience is greatly appreciated.

Phil

Looking along a row to find specific values
 

Hi Pete,

The data to be interrogated is in the following columns:

X, Y, AA, AB, AC, AD, AE
and AH.

Row 1 is a header, with rows 2 - 250 holding details of the assets
along with the measurement data.

Anything that does not meet either of the criteria should be green, those
over 1450 should be red and those between 1439 and 1449 yellow.

Many thanks for your time and patience.

Phil



"Pete_UK" wrote:

Which columns are used for your 8 readings?

How many rows of data do you have?

What colours do you want for your 3 conditions?

Pete



On Feb 9, 12:04 pm, PhillyD wrote:
I posted this question a few days ago but didn't really get anything I could
use, so in an attempt to phrase my question better, here goes:

I have a spreadsheet in to which users enter measurements. Each row is for
an individual asset, however, there are 8 readings entered on the row for
measurements along a particular asset. The columns are not sequential either!

I need a method which will:

1. Tell me of any values greater than or equal to 1439, but less than or
equal to 1449
2. Tell me of any values greater than or equal to 1450
3. Tell me of any values less than 1439.

I had thought conditional formatting would be the way ahead but I can't work
out how to get Excel to look along the row, rather than in just one cell.

Your help and patience is greatly appreciated.

Phil

Looking along a row to find specific values
 

Try this

1) Select the range that you want to apply Conditonal Format, these cells
will then br highlighted
2) Format Conditional Formating
3) Under Condition 1,
a) select Cell Value Is
b) select between from the dropdown
c) type =1439
d) type <=1449
4) Click on Format and go to Pattern and apply the yellow color you want

5) Under Conditon 2, repeat a) from the above
b) select greater than or equal to
c) type 1450 and apply the red color format
6) Under Condition 3, select less than and type 1439
then apply the green color format

if any of the cells value in the selected range are not equal to
condition 1, the cell will fill with Yellow
condition 2, Red
condition 3, Green

Is this what you want?

--
HTH

Pls provide your feedback by clicking the YES button below if this posting
is helpful
This will help others to search the results in the archive better

cheers, francis

"PhillyD" wrote in message
...
Hi Pete,

The data to be interrogated is in the following columns:

X, Y, AA, AB, AC, AD, AE
and AH.

Row 1 is a header, with rows 2 - 250 holding details of the assets
along with the measurement data.

Anything that does not meet either of the criteria should be green, those
over 1450 should be red and those between 1439 and 1449 yellow.

Many thanks for your time and patience.

Phil



"Pete_UK" wrote:

Which columns are used for your 8 readings?

How many rows of data do you have?

What colours do you want for your 3 conditions?

Pete



On Feb 9, 12:04 pm, PhillyD wrote:
I posted this question a few days ago but didn't really get anything I
could
use, so in an attempt to phrase my question better, here goes:

I have a spreadsheet in to which users enter measurements. Each row is
for
an individual asset, however, there are 8 readings entered on the row
for
measurements along a particular asset. The columns are not sequential
either!

I need a method which will:

1. Tell me of any values greater than or equal to 1439, but less than
or
equal to 1449
2. Tell me of any values greater than or equal to 1450
3. Tell me of any values less than 1439.

I had thought conditional formatting would be the way ahead but I can't
work
out how to get Excel to look along the row, rather than in just one
cell.

Your help and patience is greatly appreciated.

Phil

Looking along a row to find specific values
 

Hi xlmate,

I can't use conditional formatting for two reasons:

1. Conditional formatting already exists in these cells to highlight values
reaching certain intervention limits
2. I need something that will interrogate the values along the row and only
act if it finds either =1439, <=1449 OR 1450.

Ideally, if it was written in to a macro control button to only output the
records matching criteria set by the user it would be ideal but a simple
output to another worksheet of those assets matching the criteria would be
ideal for now.

Thanks for your suggestion.

"xlmate" wrote:

Try this

1) Select the range that you want to apply Conditonal Format, these cells
will then br highlighted
2) Format Conditional Formating
3) Under Condition 1,
a) select Cell Value Is
b) select between from the dropdown
c) type =1439
d) type <=1449
4) Click on Format and go to Pattern and apply the yellow color you want

5) Under Conditon 2, repeat a) from the above
b) select greater than or equal to
c) type 1450 and apply the red color format
6) Under Condition 3, select less than and type 1439
then apply the green color format

if any of the cells value in the selected range are not equal to
condition 1, the cell will fill with Yellow
condition 2, Red
condition 3, Green

Is this what you want?

--
HTH

Pls provide your feedback by clicking the YES button below if this posting
is helpful
This will help others to search the results in the archive better

cheers, francis

"PhillyD" wrote in message
...
Hi Pete,

The data to be interrogated is in the following columns:

X, Y, AA, AB, AC, AD, AE
and AH.

Row 1 is a header, with rows 2 - 250 holding details of the assets
along with the measurement data.

Anything that does not meet either of the criteria should be green, those
over 1450 should be red and those between 1439 and 1449 yellow.

Many thanks for your time and patience.

Phil



"Pete_UK" wrote:

Which columns are used for your 8 readings?

How many rows of data do you have?

What colours do you want for your 3 conditions?

Pete



On Feb 9, 12:04 pm, PhillyD wrote:
I posted this question a few days ago but didn't really get anything I
could
use, so in an attempt to phrase my question better, here goes:

I have a spreadsheet in to which users enter measurements. Each row is
for
an individual asset, however, there are 8 readings entered on the row
for
measurements along a particular asset. The columns are not sequential
either!

I need a method which will:

1. Tell me of any values greater than or equal to 1439, but less than
or
equal to 1449
2. Tell me of any values greater than or equal to 1450
3. Tell me of any values less than 1439.

I had thought conditional formatting would be the way ahead but I can't
work
out how to get Excel to look along the row, rather than in just one
cell.

Your help and patience is greatly appreciated.

Phil