Home |
Search |
Today's Posts |
#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. |
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) |