Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I format an entire row based on the value of a single cell?
I would like to use the conditional formatting feature to format an entire
row rather than just a single cell. For example: If the cell value = "Total" then the entire row is bold. |
#2
|
|||
|
|||
select your range (multiple rows???).
Then with A3 (say) the activecell in that selection: format|Conditional formatting formula is: =$a3="total" apply a nice format LTShelley wrote: I would like to use the conditional formatting feature to format an entire row rather than just a single cell. For example: If the cell value = "Total" then the entire row is bold. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing based on format | New Users to Excel | |||
New column based on row cell format | Excel Discussion (Misc queries) | |||
How to apply a format to an entire workbook | Excel Worksheet Functions | |||
Formatting an entire row based on one cell | Excel Worksheet Functions | |||
formula based on format | Excel Discussion (Misc queries) |