I've notice that in Datasheet view, Conditional Formatting seems to have a subtle flaw: it forces a background color change that interrupts the natural flow of "Alternating Row Color". See attached pic and notice how the alt row color is greyish, but the Conditionally Formatted cells (they have red text) forces a White background which, over the course of a large datasheet, makes it ugly.
Any way around this or should I live with it? I've checked for a transparent BG color but couldn't find it. I also went into design view and set the Back Style as Transparent and played with options a bit to no avail.
Ty for any thoughts
Matt