I have to admit that I'm no excel expert. I have been playing around with
VBA trying to format the color of a row. I use conditional formatting on
cell C1. If C1=Y then I turn it green. If C1=N then I turn it red. I would
like to know how to turn either the entire row a or a range (A1:A2) within
that row to follow the format of cell C1.