Excel 2007: Color cells that meet criteria using conditional formatting
Filed in Excel on Nov.27, 2007. Email This article to a Friend
Problem: Color cellrow(s) with column A less than 50 and column B = 0
Solution:
Example sheet

Instructions:
- Select the whole area you want to use "conditional formatting" on
- Go to tab "Home"
- Click "Conditional formatting"
- Click "New rule..."
- Click "Use a formula to determine which cells to format"
- In "Format values where this formula is true" type =AND($A1<50,$B1=0)
- Click "Format" button
- Click "Fill" tab
- Choose a color
- Click ok!
- Click ok!
- Click ok!

Related blog posts
- Color every second row using conditional formatting in excel
- Highlight duplicates where adjacent cell value meets criteria using conditional formatting in excel
- Highlight dates within a date range using conditional formatting
- Highlight the second or more duplicates in two lists using conditional formatting in excel
- Highlight duplicates using conditional formatting in excel






December 12th, 2007 at 8:06 am
b = 1 or b = 0 ???
December 12th, 2007 at 3:24 pm
Thank you!