View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DFrank DFrank is offline
external usenet poster
 
Posts: 28
Default Conditional Formatting Question

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