Conditional Formatting in Rows

[martinpaiva]

Hi Guys,

I'm having some problems when I tried to applied a conditional formatting for multiple cells in a row.

I have some data for employees that should be updated in some time. I have a column to entry the last time when a record was updated. Then I want to create a conditional formatting to highlight the records that are between 30 days and 90 days ago.

For some reason when I applied the conditional formating, these only applied for the first cell and not all the row.

Here is the spreadsheet that I'm using.
https://dl.dropboxusercontent.com/u/...attingTest.xls

Any idea? What's im doing wrong?

Regards,

[martinpaiva]

Any idea? I can't find a related thread on the forum.

[CdeBurca]

Have you selected just the first cell or the whole row?

When I -

• Select the whole row (by left-clicking on the "I")
• bring up Conditional Formatting (ALT, O, D)
• click add New Rule
• click Use a formula to determine which cells to format
• and then copy and paste your formula in from the K column

- it works grand. I'm in Excel 2007 AFAIK.

Possibly you're just selecting the first cell?

[martinpaiva]

Hi CdeBurca,

I selected all the columns that I want to applied the conditional formating from C3 to H3. But for some reason works only for C3. I saw on google that I should remove the "$" from the formula, I tried to do that but then the symbol re insert automatically.

Capture.PNG

[CdeBurca]

Sorry, I see what you mean now.

Yeah, if you put a $ before every I in the formula, it should work.

When the formula is in C column, it's picking up the dates in column I. When you move one row to the right (column D), the formula moves one to the right too, so it starts looking at dates in column J, which is blank.

Putting in the $ before the I means the formula won't jump like that.

Also, you should change =$C$3:$H$3 to $C$3:$H$100 so all the rows are included.

Does that help?

[martinpaiva]

Hi CdeBurca,

Hey now works! Thank you so much!

Regards,