| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expand Conditional Formatting to all Rows
Apply the Conditional Formatting to the range.
"KKD" wrote: I'm actually asking a different question. How do I expand the formatting I have to apply to each individual row? I can get one row to work, but short of copying this 2000 times, I don't know how to make this rule apply to each row. -- KKD "trip_to_tokyo" wrote: KKD, check this out as I think it may assist. EXCEL 2007 take the following actions:- 1. Go into F 1 Help Facility and type in:- conditional formatting 2. Hit the Search, "button". 3. There is a topic called:- Conditionally formatted data: Examples and guidlines 4. Click on the above topic. 5. Opening the above topic there is a hyperlink about three quarters of the way down the page called:- Conditional Formatting Samples 6. Click on the above hyperlink. 7. A file will open. Take a look at the Worksheet called:- Products3 This is about:- "Shade an entire row where several criteria must be true" This seems to be what you want. I have worked through this example myself and it is, "spot on". Please hit Yes if my comments have helped. Thanks. "KKD" wrote: I cannot get my conditional formatting rule to apply to my entire data set. My data are set in rows. I want the entire row to format (color fill) when two specific cells within that row equal each other. I can get the single row to work properly, but I can't see how to expand this formula down to each row on my worksheet. I have read several other posts regarding this issue but am still not able to get it to work, can someone help me out? -- KKD |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting 2 rows only | Excel Discussion (Misc queries) | |||
| Conditional Formatting Rows | Excel Discussion (Misc queries) | |||
| Conditional formatting for rows? | New Users to Excel | |||
| Conditional Formatting of rows | Excel Discussion (Misc queries) | |||
| How to get more than 3 rows in Conditional Formatting | Excel Discussion (Misc queries) | |||
![trip_to_tokyo[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
