Ok, lets start over.
Conditional Formatting is based on the active cell. You
can copy the formatting using the format painter -- though
it would actually be better to do all of your formatting even if
for the entire column ahead of time. My page on C.F. is http://www.mvps.org/dmcritchie/excel/excel.htm
I would suggest you always use formulas in C.F. rather than
the phrased comparisons. That way you get used to working with
them in a more consistent manner. And if you ever want to try to
show the formula with programming means, you will have better luck
at that as well.
If you want the Entire row to turn color,
Ctrl+A with cell A1 as the Activecell
Format 1: =$A1 < ($B1+.01) --- blue
Format 2: =$A1 > ($B1+.01) --- yellow
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
