Colorize rows in Excel

[Daniellekenny]

Hello,

I have a table in excel listing our organization members. I would like to colorized the inactive members for more than 30 days in red and the inactive members for less than 30 days in orange.

I believe I need to use conditional formatting to achieve that. But how can I tell excel to look in my column B to see if the member is listed as "inactive member" and then look into column E to see for how many days the company was inactive.

Also, I seem to be able to colorize one cell based on one condition but not the whole row.

Thanks a lot!

[jeffreybrown]

Try...

Conditional Formatting

• Highlight applicable range >> A2:K100
• Home Tab >> Styles >> Conditional Formatting
• New Rule >> Use a formula to determine which cells to format
• Edit the Rule Description: Format values where this formula is true: =AND($B2="Inactive Member",$E2>=30)
• Format… [Number, Font, Border, Fill] >> Red
• OK >> OK

Now add another rule but switch the formula to:

=AND($B2="Inactive Member",ISNUMBER($E2),$E2<30)

and Orange fill

Note: Highlight whatever range is applicable, A2:K100 was just a sample

[Daniellekenny]

Thanks a lot Jeff!

I was able to colorize the member's cell orange and red according to my conditions, but the entire row wasn't colorized. Is there a way I could do that?

[jeffreybrown]

When you say the entire row, do you literally mean from A to the end of the spreadsheet (16,000 + columns)?

If you highlight the applicable range all will work fine.

If you want to post your sample workbook and what you are doing maybe there is something going wrong...

[Daniellekenny]

Never mind I figured it out!

I only selected the first column, if I select all the columns in my table, it will highlight the entire row

Thank you

[jeffreybrown]

You're welcome…glad you have a workable solution and thanks for the feedback...

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

I'll mark it for you.