Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare dates
I have invoice numbers in column A (1234567ABC)
Date of invoice is in column B in this format 31-Mar-09 Date of product received is in column C in this format 04/15/09 I need to highlight in yellow each cell in column B (date of invoice) if it is greater than a cell in column C (date of product received). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare dates
Dates are just numbers to Excel, so conditional formatting will work, as in:
=B1C1 and copy down your column. Regards, Fred "Vic" wrote in message ... I have invoice numbers in column A (1234567ABC) Date of invoice is in column B in this format 31-Mar-09 Date of product received is in column C in this format 04/15/09 I need to highlight in yellow each cell in column B (date of invoice) if it is greater than a cell in column C (date of product received). |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare dates
Hi Fred,
This did not solve anything. My taks is to highlight B cells if they are greater than C cells. Please keep in mind that some C cells may be blank (product was not received yet) - I don't want to highlight corresponding B cell in this case. Thank you. "Fred Smith" wrote: Dates are just numbers to Excel, so conditional formatting will work, as in: =B1C1 and copy down your column. Regards, Fred "Vic" wrote in message ... I have invoice numbers in column A (1234567ABC) Date of invoice is in column B in this format 31-Mar-09 Date of product received is in column C in this format 04/15/09 I need to highlight in yellow each cell in column B (date of invoice) if it is greater than a cell in column C (date of product received). |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare dates
Your problem likely is that column B is not a date, it's text. So you need
to force Excel to evaluate it. At the same time, add the check for column C being blank. The following will do what you requested: =AND(C1<"",--B1--C1) Regards, Fred. "Vic" wrote in message ... Hi Fred, This did not solve anything. My taks is to highlight B cells if they are greater than C cells. Please keep in mind that some C cells may be blank (product was not received yet) - I don't want to highlight corresponding B cell in this case. Thank you. "Fred Smith" wrote: Dates are just numbers to Excel, so conditional formatting will work, as in: =B1C1 and copy down your column. Regards, Fred "Vic" wrote in message ... I have invoice numbers in column A (1234567ABC) Date of invoice is in column B in this format 31-Mar-09 Date of product received is in column C in this format 04/15/09 I need to highlight in yellow each cell in column B (date of invoice) if it is greater than a cell in column C (date of product received). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare 2 tables of dates to find the preceding dates | Excel Worksheet Functions | |||
Compare dates with lag | Excel Worksheet Functions | |||
compare dates using a variable | Excel Worksheet Functions | |||
compare dates | Excel Worksheet Functions | |||
how do I compare two dates? | Excel Worksheet Functions |