Conditional Formatting

[Gos-C]

Hi Everyone,

Using the following as an example:

Data is in C3:E7

Column C

1111
1111
1111
1111
1111

Column D

09-Jan-06
09-Jan-06
01-Feb-06
01-Feb-06
09-Jan-06

Column E

Blank
Blank
Blank
Blank
07-Feb-06

I highlighted cells H3:S1002 and entered =AND(C3<>"",ISNUMBER(MATCH(C3&D3&E3,$C1:C2&$D$1:D2&$E1:E2,0))) for Conditional Formatting but only the cell in Column H (instead of all the cells in Columns H to S) is formatted where C, D and E match. Is my formual incorrect? If so, can someone give me the correct formula.

Thanks,
Gos-C

[HS Hartkamp]

Could it be that you'd want absolute references in the formula ? (i.e. put
some $ in there?) You can check that by selecting some cell in column S and
looking at what conditional formatting that cell has got.

Bas Hartkamp.


"Gos-C" <Gos-C.23l5wm_1140536400.8094@excelforum-nospam.com> schreef in
bericht news:Gos-C.23l5wm_1140536400.8094@excelforum-nospam.com...
>
> Hi Everyone,
>
> I highlighted cells H3:S1002 and entered
> *=AND(C3<>"",ISNUMBER(MATCH(C3&D3&E3,$C1:C2&$D$1:D2&$E1:E2,0)))* for
> Conditional Formatting but only the cell in Column H (instead of all
> the cells in Columns H to S) is formatted where C, D and E match. Is
> my formual incorrect? If so, can someone give me the correct formula.
>
> Thanks,
> Gos-C
>
>
> --
> Gos-C
>
>
> ------------------------------------------------------------------------
> Gos-C's Profile:
> http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=514917
>

[Herbert Seidenberg]

Assuming you meant $D1 instead of $D$1
Try
=NOT(((C3&D3&E3)<>($C1&$D1&$E1))*((C2&D2&E2)<>($C1&$D1&$E1)))*(C3<>"")