Subscribe!

Q:
Dear ExcelYogi,
Thank you for all your wonderful advise and guidance! I am hoping you can help me yet again. I understand the basics of conditional formatting, but is it possible to do something more advanced such as highlighting entire rows based on a criteria?

Thanks again!
Amber

A:
Amber,
I see this question often. It is much more simple than you think. Lets assume you have data in a table from A1:D6, and you want to find values in column D that are greater than 100, and highlight the entire row.

Step 1:
Highlight A1:D6

Step 2:
Click Format > Conditional Formatting on the toolbar. Select “Formula is” in the first drop-down and enter “=$d1>100″. Click the Format button and apply the formatting of your choosing.
That’s it!

Related posts:

  1. Conditional Formatting with Multiple Criteria in Excel Microsoft Excel has a limit of 3 criteria in Conditional...
  2. Excel CELL () Function The CELL function can be used to find out information...

This entry was posted on Thursday, October 23rd, 2008 at 1:12 pm and is filed under Mail Bag. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Conditional Formatting”

  1. Dan on October 23rd, 2008 at 1:14 pm

    Nice!

  2. Analyst Pulpit » Blog Archive » Conditional Formatting with Multiple Criteria in Excel on February 3rd, 2009 at 3:45 pm

    [...] Excel has a limit of 3 criteria in Conditional Formatting. We can get around this with a bit of VBA [...]

Leave a Reply

You must be logged in to post a comment.