View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tmaxx02 Tmaxx02 is offline
external usenet poster
 
Posts: 10
Default Can Conditional Formatting do this?

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