Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting Question | Excel Discussion (Misc queries) | |||
Conditional Formatting Question | Excel Discussion (Misc queries) | |||
Conditional Formatting Question | Excel Discussion (Misc queries) | |||
Another Conditional Formatting Question | Excel Worksheet Functions | |||
Conditional Formatting question... | Excel Discussion (Misc queries) |