Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Highlighting a row with conditional formatting

How do I format a row with conditional formatting?
--
Rob
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default Highlighting a row with conditional formatting

Really depends on your condition, doesn't it?

Say the condition is that the cell in column D is "Yes"

Then, highlight the row(s) to CF and enter (assume row 1 is active)


CF1: Formula is =$D1="Yes"
Format1: <pattern/<highlight color

XL will adjust the reference for additional rows.

In article ,
Rob wrote:

How do I format a row with conditional formatting?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default Highlighting a row with conditional formatting

Select all the cells in the particular row(s) that you wish to be governed
by the CF formula, *before* you start the Conditional Formatting.

For example, say you wanted to highlight A1 to G1 to a yellow pattern and a
red font *only when* A1 was greater then 10.
And you wanted this to include the first 10 rows, to be determined by the
cell value in Column A, from A1 to A10.

So, select A1 to G10, with the focus of the selection in A1 (A1 is white),
*then*:
<Format <Conditional Formatting,
Change "Cell Value Is" to
"Formula Is", and enter this formula:

=$A110

The absolute reference to Column A ($A) dictates that *only* the Column A
cell values control the formatting of the selected row cells.

Click on "Format", and choose your font and/or pattern color, then <OK out.

You have now set the conditional format for the first 10 rows, from Column A
to Column G.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Rob" wrote in message
...
How do I format a row with conditional formatting?
--
Rob


  #4   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Highlighting a row with conditional formatting

Thanks for your response.

What I am still unable to do is have a row highlighted in a red pattern with
a bold white font when a condition is met.

For example, in the range A3 through C14, find the dollar amount greater
than $30 in column C, then highlight the entire row (A, B, and C) in red.

Any suggestions?

--
Rob


"Ragdyer" wrote:

Select all the cells in the particular row(s) that you wish to be governed
by the CF formula, *before* you start the Conditional Formatting.

For example, say you wanted to highlight A1 to G1 to a yellow pattern and a
red font *only when* A1 was greater then 10.
And you wanted this to include the first 10 rows, to be determined by the
cell value in Column A, from A1 to A10.

So, select A1 to G10, with the focus of the selection in A1 (A1 is white),
*then*:
<Format <Conditional Formatting,
Change "Cell Value Is" to
"Formula Is", and enter this formula:

=$A110

The absolute reference to Column A ($A) dictates that *only* the Column A
cell values control the formatting of the selected row cells.

Click on "Format", and choose your font and/or pattern color, then <OK out.

You have now set the conditional format for the first 10 rows, from Column A
to Column G.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Rob" wrote in message
...
How do I format a row with conditional formatting?
--
Rob



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default Highlighting a row with conditional formatting

One way:

Select A3:C14 with A3 active. Choose Format/Conditional formatting...
Set the dropdowns and input box to read

CF1: Formula is =$C330
Format1: <pattern/<red, <font/<white<bold

In article ,
Rob wrote:

What I am still unable to do is have a row highlighted in a red pattern with
a bold white font when a condition is met.

For example, in the range A3 through C14, find the dollar amount greater
than $30 in column C, then highlight the entire row (A, B, and C) in red.

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
Conditional formatting - Highlighting a row Coco Excel Worksheet Functions 6 February 24th 07 09:58 PM
Conditional formating - Highlighting items in a separate column AFSSkier Excel Discussion (Misc queries) 2 June 7th 06 04:38 PM
Highlighting an entire row using conditional formatting. SystemHack Excel Worksheet Functions 5 January 27th 06 02:24 AM
Highlighting text using conditional formatting Greshter Excel Discussion (Misc queries) 2 July 14th 05 04:04 AM
HELP ME PLEASE!! CONDITIONAL FORMATING HIGHLIGHTING CELLS. ANDREW_B Excel Discussion (Misc queries) 1 December 2nd 04 05:12 PM


All times are GMT +1. The time now is 05:15 AM.

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

About Us

"It's about Microsoft Excel"