Conditional formatting a pair of numbers

Hi, I would like your help in formatting.
I would like to color in a table A1: E22, the pair of numbers found in the G1-H1
Only if both present and not just one.
thanks

numeri-doppi.zip

Hi Berna11

Conditional formatting: =OR(A1=15,A1=32)

Select all the cells from A1 to E22, click on Conditional Formatting | New Rule | Use a formula ... , and then put this formula in the formula box:

=OR(AND(A1=$G$1,COUNTIF($A1:$E1,$H$1)>0),AND(A1=$H$1,COUNTIF($A1:$E1,$G$1)>0))

Then click the Format button, then the Fill tab, and choose your colour. Then OK your way out, and Excel will adjust those cell references as appropriate.

Hope this helps.

Pete

Hi @ Kevin numbers can vary in G1-H1
@ Pete your formula is not working for me one or two?
* ... $ H $ 1)> 0) and (A1 = $ H $ 1, ...?
Could you send me the file with the example?
thanks

Originally Posted by Berna11

Could you send me the file with the example?

File attached, as requested.

I've been playing about with different numbers in G1/H1.

Hope this helps.

Pete

Hi,
@ Kevin colors even when there is only one number and not both.
@ Pete Ok! works perfectly
I had forgotten to replace a (,) with ( excel Italian.
Thanks a lot.