TranceAddict Forums Archive > Archives > Classic old threads / Inactive Forums > Retired Forums > Frequently Asked Questions / Tutorials / How do I? excel question View this Thread in Original format Trancealot whats the difference between $A$1 and $A1 I was learning this conditional format thing and if you use the first one then it will not work(diff colors for each row) but if you use the 2nd one then it works boggles me? Dr. Cfire quote: Originally posted by Trancealot whats the difference between $A$1 and $A1 I was learning this conditional format thing and if you use the first one then it will not work(diff colors for each row) but if you use the 2nd one then it works boggles me? The $ indicates that the value is constant when the formula is filled/copied $A1 will hold the Column A constant when formulas are filled/copied A$1 will hold the row 1 constant when formulas are filled/copied $A$1 will hold both Column A and row 1 constant when formulas are filled /copied. CLICK TO RETURN TO TOP OF PAGE

Privacy Statement