conditional formate
 

Is it possible to have a group of cells, say columns A through E and rows 1
to 15 filled with number values become hightlighted if on the same spread
sheet, they match entries a row of cells where numbers entered match? My idea
is to populate a series of cells one at a time with numbers, and as they are
entered, if they occur elsewhere in the original group, they become
highlighted.

conditional formate
 

Hi,

Select the region where you want the cells to change if the entry matches
one of the entries in the range A1:E15 and choose Format, Conditional
Formatting, from the first drop down choose Formula is, in the second box
enter the formula
=OR(H1=$A$1:$E$15)
Click the Format button and on the Patterns tab pick a color.

--
Thanks,
Shane Devenshire


"charts for fun" wrote:

Is it possible to have a group of cells, say columns A through E and rows 1
to 15 filled with number values become hightlighted if on the same spread
sheet, they match entries a row of cells where numbers entered match? My idea
is to populate a series of cells one at a time with numbers, and as they are
entered, if they occur elsewhere in the original group, they become
highlighted.

conditional formate
 

Forgot to mention that the cell H1 is the first cell in the range you want to
format
=OR(H1=$A$1:$E$15)
--
Thanks,
Shane Devenshire


"charts for fun" wrote:

Is it possible to have a group of cells, say columns A through E and rows 1
to 15 filled with number values become hightlighted if on the same spread
sheet, they match entries a row of cells where numbers entered match? My idea
is to populate a series of cells one at a time with numbers, and as they are
entered, if they occur elsewhere in the original group, they become
highlighted.