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.
|