You define three conditions. First should be the combination of both
with AND:

=AND(=MOD(ROW()-2,2*1)+2<=2,A1="Y")

In this case set both color and bold.
Second should be only the MOD condition, here you only set the color.
Third should be only the "Y" condition and you set bold.

HTH
Kostis Vezerides

On Jun 27, 4:16 pm, DFrank wrote:
I am working with a spreadsheet that I want 2 conditional formats present.
The first is alternating the row color between white and light green using
=MOD(ROW()-2,2*1)+2<=2. The second is to bold and change the color (pretty
much just make stand out) any value that is 'Y' (this is a Y/N spreadsheet).

When I input both conditions the rows alternate colors, but only the white
rows bold the 'Y.'

How can i make it so that both the green and white shaded rows bold and
color the 'Y' value?

Included is a picture of the layout and the conditional formatting input:http://img71.imageshack.us/img71/196...uestionpf0.jpg

Thanks