| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing font using conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting for changing data | Excel Discussion (Misc queries) | |||
| Conditional Formulas for Changing Cell Color | Excel Worksheet Functions | |||
| Changing text color usinf a formula (NOT Conditional Formatting) | Excel Discussion (Misc queries) | |||
| Conditional color formatting entries have wild color. | Excel Discussion (Misc queries) | |||
Linear Mode
