Conditional Formatting Between Multiple Columns

**p_arab** · 02-13-2013, 05:06 PM

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

**Moo the Dog** · 02-13-2013, 05:37 PM

Select the range in column C you want conditionally formatted, and add these two conditional formatting rules:

For RED (must be listed first): =AND($A2<>"",$B2>0)
For GREEN: =$A2<>""

- Moo

**p_arab** · 02-14-2013, 03:30 PM

Moo that seemed to do the trick. I had to change it around a bit because my real sheet was not as straightforward as the example, but once I worked it out your solution is great. Thank you.