| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW CAN I APPLY CONDITIONAL FORMATTING BASED TO AN ENTIRE ROW?
I have a reasonably large spreadsheet (about 2000 rows) and i need to format
each row based on the value of a cell in a specific column. For example, if there is a "B" in Cell I20, I need to fill the whole of Row 20 with the colour green. I then need to apply this to every row. Similarly if there is a different letter, I need to make the row a different colour... All help gratefully appreciated! J |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting Entire Row Based on single Cell Value | Excel Discussion (Misc queries) | |||
| Conditional Formatting an entire row based on one cell's value. | Excel Discussion (Misc queries) | |||
| Conditional Formatting based on entire column | Excel Worksheet Functions | |||
| HOW CAN I APPLY A COLOR TO ENTIRE ROW USING CONDITIONAL FORMATT | Excel Worksheet Functions | |||
| Conditional formatting of an entire row based on a cell text entry | Excel Discussion (Misc queries) | |||
![James M[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
