Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old 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
Default 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   Report Post  
Old 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
Default 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   Report Post  
Old 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
Default 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   Report Post  
Old 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
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
changing font using conditional formatting Milind Keer[_2_] Excel Discussion (Misc queries) 1 November 6th 09 02:27 PM
Conditional formatting for changing data Mariliz Excel Discussion (Misc queries) 4 November 6th 08 06:27 PM
Conditional Formulas for Changing Cell Color mw2222 Excel Worksheet Functions 2 October 6th 08 08:42 PM
Changing text color usinf a formula (NOT Conditional Formatting) John Elliott Excel Discussion (Misc queries) 7 June 11th 06 07:30 AM
Conditional color formatting entries have wild color. John Geyer Excel Discussion (Misc queries) 0 February 24th 06 06:11 PM


All times are GMT +1. The time now is 11:37 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017