Remember Me?

#1
August 9th 11, 05:23 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jan 2009 Posts: 54
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
August 9th 11, 07:45 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2011 Posts: 86
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
August 15th 11, 02:13 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jan 2009 Posts: 54
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
August 15th 11, 08:33 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2011 Posts: 86
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 ---

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Milind Keer[_2_] Excel Discussion (Misc queries) 1 November 6th 09 02:27 PM Mariliz Excel Discussion (Misc queries) 4 November 6th 08 06:27 PM mw2222 Excel Worksheet Functions 2 October 6th 08 08:42 PM John Elliott Excel Discussion (Misc queries) 7 June 11th 06 07:30 AM John Geyer Excel Discussion (Misc queries) 0 February 24th 06 06:11 PM

All times are GMT +1. The time now is 10:52 PM.