Bold text in rows (Conditional formatting XL2007)

**chaomifen** · 08-12-2010, 01:59 PM

Hi All
Can anyone advise me of a way to bold selected rows from a range if one of the cells in the rows equals a certain value.e.g

A B C D E
1 X X X Y X
2 X X X X X
3 X X X Y X

I select cells A1-E3 and if D1 = "Y" (also when D3 = "Y") then bold the whole text in rows 1 and 3 respectively.

Thanks!

Dor

**contaminated** · 08-12-2010, 02:03 PM

Try this formula in conditional formatting
=AND($D1="Y",$D3="Y")

**NBVC** · 08-12-2010, 02:04 PM

After selecting A1:E3 go Home|Conditional Formatting, New Rule

Select use formula to determine which cells to format

and then type

=$D1="Y"

Then click Format and choose from Font tab

**chaomifen** · 08-12-2010, 10:28 PM

Have tried the formulae and it works. Thanks!

What if i do not restrict the look-up array to be only 1 column, i.e. if Columns D or E contains "Y"?

I tried this: =$D1:$E1="Y" but it doesn't seem to work.....

Thanks,
Dor

**NBVC** · 08-13-2010, 01:24 PM

You'd have to enter something like this:

=OR($D1="Y",$E1="Y")

or

=COUNTIF($D1:$E1,"Y")>0 (this is more appropriate if you will have several contiguous checks of the same thing).