Thank you very much! It was extremely helpful.

"jamescox" wrote:


I copied your table of info into a worksheet starting at cell A4, so
that gives you some idea of how to adjust the cells in the formulas.

For High Med Low = 3,2,1 conversions use the following:

=IF(UPPER(D4)="HIGH",3,IF(UPPER(D4)="MOD",2,IF(UPP ER(D4)="LOW",1,"")))

For Low High Stable = 1,1,0 conversions use:

=IF(OR(UPPER(G4)="LOW",UPPER(G4)="HIGH"),1,IF(UPPE R(G4)="STABLE",0,""))

For N Y = 0,1 conversions use:

=IF(UPPER(E4)="N",0,IF(UPPER(E4)="Y",1,""))

For highlighting cells if the training is more than two months in the
past, use the following formula in a Conditional Formula:

=EDATE(B4,2) < TODAY()

Some comments:

1. These formulas could be placed in a group of cells to the right of
data entry area (Columns A through H)

2. The conversion formulas are a bit more complex than they might have
to be, but use UPPER to make sure 'mod', 'Mod', 'MoD', 'MOD' and all
such variations are recognized.

3. You could use Data Validation to put a drop-down arrow in each data
entry cell which would allow the nurses to just select an entry and not
require them to type anything.

Hope this helps...


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113743