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. |
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 |
All times are GMT +1. The time now is 09:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com