Changing the color of rows - conditional formatting
Using conditional formatting, how can I change the color of the row
(highlight) if a certain cell in the worksheet is not blank? It should check all rows for this and change them accordingly. Thanks! --- Posted via news://freenews.netfront.net/ - Complaints to --- |
Changing the color of rows - conditional formatting
Best guess based upon description.
I will assume by "certain cell in the worksheet" you mean "certain cell in each row" Select all rows to be colored. In CF use Formula is: =$A1<"" where column A is the "certain cell" in each row. Gord Dibben Microsoft Excel MVP On Tue, 9 Aug 2011 12:23:25 -0400, "Saucer Man" wrote: Using conditional formatting, how can I change the color of the row (highlight) if a certain cell in the worksheet is not blank? It should check all rows for this and change them accordingly. Thanks! --- Posted via news://freenews.netfront.net/ - Complaints to --- |
Changing the color of rows - conditional formatting
Thank you very much.
"Gord" wrote in message ... Best guess based upon description. I will assume by "certain cell in the worksheet" you mean "certain cell in each row" Select all rows to be colored. In CF use Formula is: =$A1<"" where column A is the "certain cell" in each row. Gord Dibben Microsoft Excel MVP --- Posted via news://freenews.netfront.net/ - Complaints to --- |
Changing the color of rows - conditional formatting
Thanks for the feedback.
Gord On Mon, 15 Aug 2011 09:13:33 -0400, "Saucer Man" wrote: Thank you very much. "Gord" wrote in message ... Best guess based upon description. I will assume by "certain cell in the worksheet" you mean "certain cell in each row" Select all rows to be colored. In CF use Formula is: =$A1<"" where column A is the "certain cell" in each row. Gord Dibben Microsoft Excel MVP --- Posted via news://freenews.netfront.net/ - Complaints to --- |
All times are GMT +1. The time now is 10:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com