formula assistance

D

dolingercha

I currently have a spreadsheet that has two columns that I
need to reflect using color (or someway flag it to be
noticeable) if the revenue and collections has dropped for
three consecutive months in a row. The formulas that are
being used in those columns currently =IF(J8="",0,G8) I
need to somehow put something in the code that will mark a
drop if the numbers drop 3 consecutive months in a row. I
also have column B that is either blank or contains the
word yes (which reflects a new client) and I'd like to
somehow add a code that would change the color of the
entire row if the word yes is in Column B, currently there
is no formula in Column be at all. Any help will be
greatly appreciated.
 
W

William

Hi

Have a look at Conditional Formatting within Excel help. Extract below.

1. To use a formula as the formatting criteria (to evaluate data or a
condition other than the values in selected cells), click Formula Is and
then enter the formula that evaluates to a logical value of TRUE or FALSE.
2. Click Format.
3. Select the formatting you want to apply when the cell value meets the
condition or the formula returns the value TRUE.
4. To add another condition, click Add, and then repeat steps 1 through
3. You can specify up to three conditions. If none of the specified
conditions are true, the cells keep their existing formats.


--
XL2002
Regards

William

[email protected]

| I currently have a spreadsheet that has two columns that I
| need to reflect using color (or someway flag it to be
| noticeable) if the revenue and collections has dropped for
| three consecutive months in a row. The formulas that are
| being used in those columns currently =IF(J8="",0,G8) I
| need to somehow put something in the code that will mark a
| drop if the numbers drop 3 consecutive months in a row. I
| also have column B that is either blank or contains the
| word yes (which reflects a new client) and I'd like to
| somehow add a code that would change the color of the
| entire row if the word yes is in Column B, currently there
| is no formula in Column be at all. Any help will be
| greatly appreciated.
 
E

Earl Kiosterud

Conditional formmating will do this. You'll have to tell us how the sheet
is laid out. We need to know where the three prior months are. Be
specific. Give example data, and where it is.

Ain't much cain't be did with this here Excel.

Earl Kiosterud
mvpearl omitthisword at verizon period net
 
D

dolingercha

attached is a couple sample lines from the spreadsheet I'd
asked for assistance with. Please let me know if you have
any suggestions.

Member name (a) time(B) stat DCMD (c) Coach (D)
Month/Yr (e) Services (f) Collections (g) write offs (h)
new patients (I) office visits (j) missed appts (k)
reactived patients (l) and then the formula sections
continue on to the right from there.

the months yrs are setup to continue down the page, June
for instance rows 1 -310 and then July's would beging at
313 - 613 and so on. I've inherited these spreadsheets
with the job. I need to flag columns F & G when they drop
and then notify the coach if they reach 3 consecutive
months of drops in those stats.

Thanks in advance for any assistance, I'm at a loss with
how this can be done.
 
E

Earl Kiosterud

Can you provide some sample data for these columns. Attachments get
stripped.
 
Top