Highlighting a row with conditional formatting
 

How do I format a row with conditional formatting?
--
Rob

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?

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

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

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.