Highlighting a row with conditional formatting

J

JE McGimpsey

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.
 
R

Ragdyer

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:

=$A1>10

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.
 
R

Rob

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?
 
J

JE McGimpsey

One way:

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

CF1: Formula is =$C3>30
Format1: <pattern>/<red>, <font>/<white><bold>
 
Top