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