Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How do I format a row with conditional formatting?
-- Rob |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting - Highlighting a row | Excel Worksheet Functions | |||
Conditional formating - Highlighting items in a separate column | Excel Discussion (Misc queries) | |||
Highlighting an entire row using conditional formatting. | Excel Worksheet Functions | |||
Highlighting text using conditional formatting | Excel Discussion (Misc queries) | |||
HELP ME PLEASE!! CONDITIONAL FORMATING HIGHLIGHTING CELLS. | Excel Discussion (Misc queries) |