Hi,
Can anyone help me. I am creating a spreadsheet in Excel 2000 with dates in column d that correspond to data in column c. How can I cause cells in column d to be color coded in response to column c. Example: Column D date: 12/10/11, Column C data: unpaid do not support. I know I can do this in Conditional Formatting but I do not Know the formula I should use to make it work. Please help.
Thanks