| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Entire Row
I want to know how to format the entire row if a cell within the row meets a
certain condition. I could use condtional formatting to format only the cell which meets that condition. -- Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting Entire Row
Select the entire row or portion of the row to format.
FormatCFFormula is: =$D$1=123 Your cell ref and value may differ so edit the above to suit. Main thing is to make the cell ref Absolute by inserting the $ signs as shown. Gord Dibben MS Excel MVP On Mon, 18 Dec 2006 11:29:00 -0800, Daviv wrote: I want to know how to format the entire row if a cell within the row meets a certain condition. I could use condtional formatting to format only the cell which meets that condition. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting similar to shading alternating rows | Excel Worksheet Functions | |||
| Conditional formatting using lookup | Excel Discussion (Misc queries) | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting applicable to entire column | Excel Worksheet Functions | |||
| Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Hybrid Mode
