Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Conditional formatting
I am able to format every other row with conditional formatting, but I need to take it further. The amount of rows update daily and I only want to format if there is data in that row. (It can look at the first column for a number 1) So lets say my data is from A5 - N145 today, but tomorrow it may be A5 €“ N205 or A5 €“ N20 I have no problem putting this in a macro where it will first clear all of the formatting and then reformat accordingly. Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Conditional formatting
formula is
=if $A50 format as desiredcopy format -- Don Guillett Microsoft MVP Excel SalesAid Software "DS" wrote in message ... I am able to format every other row with conditional formatting, but I need to take it further. The amount of rows update daily and I only want to format if there is data in that row. (It can look at the first column for a number 1) So lets say my data is from A5 - N145 today, but tomorrow it may be A5 €“ N205 or A5 €“ N20 I have no problem putting this in a macro where it will first clear all of the formatting and then reformat accordingly. Thanks, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Conditional formatting
.... but this is still not dynamic. Unless I am doing it wrong (probably am)
This will highlight every row that is 0 or every other row that is selected if A50 when I add: mod(row(),2)=1 to the second condition I am looking for every other row to be highlighted until the end of the data. Hope I am clear enough. Thank you. "Don Guillett" wrote: formula is =if $A50 format as desiredcopy format -- Don Guillett Microsoft MVP Excel SalesAid Software "DS" wrote in message ... I am able to format every other row with conditional formatting, but I need to take it further. The amount of rows update daily and I only want to format if there is data in that row. (It can look at the first column for a number 1) So lets say my data is from A5 - N145 today, but tomorrow it may be A5 €“ N205 or A5 €“ N20 I have no problem putting this in a macro where it will first clear all of the formatting and then reformat accordingly. Thanks, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Conditional formatting
NEVER MIND!
It is good. Yes, the way I have it will format the row even if there is no value, but it willn ot print it. (Not sure why, because I thought when I simply formatted the every other row manually, it would print just a bunch of shaded blank rows...?) Anyway, I think we have it. THANK YOU! "DS" wrote: ... but this is still not dynamic. Unless I am doing it wrong (probably am) This will highlight every row that is 0 or every other row that is selected if A50 when I add: mod(row(),2)=1 to the second condition I am looking for every other row to be highlighted until the end of the data. Hope I am clear enough. Thank you. "Don Guillett" wrote: formula is =if $A50 format as desiredcopy format -- Don Guillett Microsoft MVP Excel SalesAid Software "DS" wrote in message ... I am able to format every other row with conditional formatting, but I need to take it further. The amount of rows update daily and I only want to format if there is data in that row. (It can look at the first column for a number 1) So lets say my data is from A5 - N145 today, but tomorrow it may be A5 €“ N205 or A5 €“ N20 I have no problem putting this in a macro where it will first clear all of the formatting and then reformat accordingly. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Problem - Dynamic Formula?? | Excel Worksheet Functions | |||
Applying conditional formatting to dynamic range | Excel Discussion (Misc queries) | |||
Almost there... dynamic and conditional set of PivotItems | Excel Programming | |||
Conditional Formatting & Dynamic Range | Excel Worksheet Functions | |||
Dynamic conditional formatting | Excel Programming |