Change cell background based on another cell

[ssmith001]

I have a range of cells J5:AP23 and in this range there are some colored cells (colorindex = 3), 1 colored cell per row. I have another cell range E5:E23 that, when a date is entered in any cell in this range, I need to change the color index to 4 for any cells in the corresponding row between columns J and AP. How can I do this?

[jasoncw]

Starting with cell J5, select the entire region J5:AP23. From the menu, select Format > Conditional Formatting.

Use Formula Is: =ISNUMBER($E5)

Then select your background color.

This will change the entire row to your color if the corresponding row in column E is numeric (this includes dates).

HTH

Jason

[ssmith001]

I'm not sure that will do what I want. I am basically trying to create a monthly bill tracking spreadsheet that as soon as I pay a bill and enter the date paid into E5, I need to change the cell color. The date range J5:AP23 already have 2 conditional cell formatting formulas that I use to change the color from white to begin with. Does this make sense?

[jasoncw]

Ok, then, you are either going to need to make this the first condition (so you have a total of 3 conditions), or you will need to use VBA. It is probably easier to just use this as an extra condition.

Jason