Hi,

This may be something easy that I am overlooking, but I would appreciate any feedback out there.

I am helping maintain a spreadsheet where the users input data into multiple columns. I want to set up some color fills for the columns later in the sheet based on whether data has been input in the earlier columns.

An easy example is: column A will be Date Received, column B will be Fee Amount and column C will be Date Paid. I want to direct column C to fill with bright green if column A has a date in the corresponding cell (i.e. if A2=2/13/13 then C2 is filled with green). If there is a date in column A and an amount in column B, then the corresponding cell in column C should fill with bright red(i.e. if A2=2/13/13 AND B2=100.00 then C2 is filled with bright red).

I can do this all day long if the conditional formatting is directed to the cells where the data is input, but I cannot for the life of me get the cells in column C to change color based on input (or lack thereof) in columns A and B. Please help, and if at all possible I need to use either conditional formatting or regular formulas as macro enabled worksheets are hard to use at my place of work.

Thank you,
Paul