Using Dates in Conditional Formatting

S

Saltrams

How can I get the date in cells in column K to turn red if the dat
entered is more than (ie later than - but not equal to) the dat
already in column J ? AND
If I do that, how can I total the red occurances at the end of colum
K?
TVM
:
 
F

Frank Kabel

Hi
try the following:
- select for example K1
- goto 'Format - Conditional Format' and enter the following formula
=K1>J1

to count these don't use the color (which is difficult for conditional
format colors) but use a formula like
0SUMPRODUCT(--(K1:K50>J1:J50))
 
Top