Select D3:F4 (D3 active),
apply CF using Formula is:
=COUNTIF($D$26:$E$26,D3)
Format to taste, ok out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tmaxx02" wrote in message
...
I have numbers in rows d3 through f22:
D3 E3 F3
9 1 6
1 9 0
etc.
In d26 and E26 I have to cell that I can input numbers into:
1 9
I would like to highlight the cells with only thoses numbers, in this
case 1, and 9, but not the 6 or the 0. In other words, I want to
highlight only the cells in the row that I have inputted, and only if
the row contains both numbers.
Thanks, Terry