Formula Dependant Conditional Formatting
I am wanting conditional formatting on an entire column of data (B). Each
cell's format is dependent on the data in the cell directly to its left (A). When I select the Conditional Formatting for B1 and enter the formula to make it dependant on A1, it works fine. I then copy the formatting down the row. The only problem is that the format in all the cells are dependant on A1, not their respective cells from column A. Is there a way to copy the conditional format down a column that will cause the format's formula to change respectively like formulas in the cells themselves do? |
make sure you use a relative address, A1, not an absolute address $A$1
-- HTH RP (remove nothere from the email address if mailing direct) "LDanix" wrote in message ... I am wanting conditional formatting on an entire column of data (B). Each cell's format is dependent on the data in the cell directly to its left (A). When I select the Conditional Formatting for B1 and enter the formula to make it dependant on A1, it works fine. I then copy the formatting down the row. The only problem is that the format in all the cells are dependant on A1, not their respective cells from column A. Is there a way to copy the conditional format down a column that will cause the format's formula to change respectively like formulas in the cells themselves do? |
All times are GMT +1. The time now is 12:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com