Conditional Formatting

[Steve]

Hi, is it possible to Conditionally Format a cell based on the value
of two other cells.

For example

KI KJ KK

08/10/2013 18:55:00 158
03/07/2013 15:10:00 158
22/08/2013 18:55:00 158 *
23/08/2013 17:00:00 158
18/08/2013 15:50:00 158
07/07/2013 14:05:00 166
22/08/2013 18:55:00 158 *

In this example both cells with a * would have conditional formatting
as the data in cells KI and KJ are identical.

Hope that maes sense

Thanks in advance


Steve

 

[Claus Busch]

Hi Steve,

Am Thu, 05 Sep 2013 08:51:35 +0100 schrieb Steve:

KI KJ KK

08/10/2013 18:55:00 158
03/07/2013 15:10:00 158
22/08/2013 18:55:00 158 *
23/08/2013 17:00:00 158
18/08/2013 15:50:00 158
07/07/2013 14:05:00 166
22/08/2013 18:55:00 158 *

In this example both cells with a * would have conditional formatting
as the data in cells KI and KJ are identical.

Select KI1:KK n => Conditional Formatting => Use formula .....
=SUMPRODUCT(--($KI$1:$KI$100=$KI1),--($KJ$1:$KJ$100=$KJ1),--($KK$1:$KK$100=$KK1))>1


Regards
Claus B.