Use conditional formatting on a range of cells

**musik7** · 01-23-2013, 03:47 PM

Hello. What I am trying to do, is apply conditional formatting to a range of cells (for example, A2:J2) based on whether the data in one of the cells (D2) contains "Yes" or "No". I would like the entire range of cells to be one color if D2 contains "Yes", and another color if D2 contains "No". If needed, this can be split into 2 different conditional formatting rules.

Thanks for the help!

Andrew

**scott.s.fower** · 01-23-2013, 04:56 PM

Edit Formatting Rule/Use a formula to determine which cells to format/=$D$2="yes"

Edit Formatting Rule/Use a formula to determine which cells to format/=$D$2="no"

**musik7** · 01-23-2013, 05:04 PM

I apologize, I should have added more info. That does work, but I need the formula to affect an entire block of cells, highlighting a particular line based on column D in that row.

For example, if D3 is "No", I need A3:J3 to be highlighted in red. If D25 is "Yes", I need A25:J25 to be highlighted green.

If you need any additional info, please let me know.

Thanks,

Andrew

**scott.s.fower** · 01-23-2013, 10:13 PM

i think i got it now

select the cells that you want to format based on $D$2 ie $d$3:$D$7

conditional formatting/add new rule/use a formula to determine which cells to format/=$D$2="yes"

**FDibbins** · 01-24-2013, 01:27 AM

assuming you want to apply this to a whole range of rows, you need to adjust the absolute reference...
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =$D2="Yes" and =$D2="No"