conditional formate

[charts for fun]

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.

 

[ShaneDevenshire]

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.

 

[ShaneDevenshire]

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