View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Can Conditional Formatting do this?

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