Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
These formulas work WONDERFUL, thanks to one of you who was kind enough to
help me out with them. I want to use them to do one more thing, and I'm not sure how to adjust it. These select the ENTIRE row for bold or highlighting. I wish to have them select the row, but only from Column A through X. =OR(AND($K1=13,$K1<=98),$K1100) and =AND($K1=99,$V1=0) Currently when this funciton goes, it tacks on a bunch of extra empty columns, making it not printer friendly. I figured there must be a way to have it only do the range I want, and not add any extra columns. THANKS!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
It looks like the conditional formating is applied to those extra columns.
You can remove it by selecting the columns that don't need to be highlighted and use the delete button on Format-Conditional formating. Hope this helps, Miguel. "bodhisatvaofboogie" wrote: These formulas work WONDERFUL, thanks to one of you who was kind enough to help me out with them. I want to use them to do one more thing, and I'm not sure how to adjust it. These select the ENTIRE row for bold or highlighting. I wish to have them select the row, but only from Column A through X. =OR(AND($K1=13,$K1<=98),$K1100) and =AND($K1=99,$V1=0) Currently when this funciton goes, it tacks on a bunch of extra empty columns, making it not printer friendly. I figured there must be a way to have it only do the range I want, and not add any extra columns. THANKS!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |