Conditional Formatting Anomaly

R

Rutgers_Excels

No, because I want it to say in the B column, but when I copy it down
want the row to change. Any ideas
 
D

David McRitchie

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
 
Top