Using Dates in Conditional Formatting

  • Thread starter Thread starter Saltrams
  • Start date Start date
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
:
 
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))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional formating dates, please help me 1
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Conditional Formatting 8
EXCEL Conditional Formatting 3
conditional formatting 7
Conditional Formatting Dates 1
Trouble w/ conditional formatting and dates 5
adding text according to col with equal date 2

Back
Top