MS Excel Formula Query

[Rik]

Could someone help me create a formula a spreadsheet.

I would like a formula that would flag up, when an
employee has been in employment for over a month for their
induction.

Cheers

Rik

 

[Bob Greenblatt]

Could someone help me create a formula a spreadsheet.

I would like a formula that would flag up, when an
employee has been in employment for over a month for their
induction.

Cheers

Rik

I have no idea what "flag up" means, but check into conditional formatting.

 

[Rik]

-----Original Message-----

Bob

what I mean by Flag Up, is that when an employee has been
in traing for over a month, i would like the employee's
name to be highlighted, or change colour on the name.

Regards

You can do this with a macro. Or, if you have another column next to the
name for your flag, you can enter a formula that computes the time in
training. And, when it exceeds a certain value the cell will highlight via
conditional formatting of the cell.

--
Bob Greenblatt [Excel MVP]
(e-mail address removed)
www.bandlassoc.com

Would it be possible for you to show me an example of a formula for this, thank - you

 

[Bernard Rey]

Rik wrote :

Would it be possible for you to show me an example of a
formula for this, thank - you

Let's say in cells A2:A20 you have the names of the employees, and in B2:B20
the date corresponding to their first day in employment.

Select cell A2. In the "Format" Menu, select the "Conditional Formatting..."
item, thus opening a pop-up Window.

In this Window, toggle the first field to "The formula is".

In the next field, type: "=B2<(NOW()-30)" (without the quotes)

Now, click the "Format..." button, and set the format you want to see when
this condition is filled (Bold Font, Red Background...)

Click the "OK" button. Copy the cell. Select cells A3:A20 and "Paste
Special..." from the "Edit" Menu, having the "Format" button checked.

The names in Col A should come out as expected when the employees are in
employment for more than 30 days now. If this doesn't give the expected
results, let us know from what point it seems to go wrong,


---------------------------------------------------------
Please reply to the newsgroup, and within the same thread.
Merci de répondre au groupe, et dans l'enfilade.

--
Bernard Rey - Toulouse / France
MVP - Macintosh


Rik wrote :

-----Original Message-----
Could someone help me create a formula a spreadsheet.

I would like a formula that would flag up, when an
employee has been in employment for over a month for their
induction.

Cheers

Rik, I have no idea what "flag up" means, but check into
conditional formatting.

--
Bob Greenblatt [Excel MVP]
(e-mail address removed)
www.bandlassoc.com


Bob

what I mean by Flag Up, is that when an employee has been
in traing for over a month, i would like the employee's
name to be highlighted, or change colour on the name.

Regards
.

You can do this with a macro. Or, if you have another column next to the
name for your flag, you can enter a formula that computes the time in
training. And, when it exceeds a certain value the cell will highlight via
conditional formatting of the cell.

 

[Rik]

Bernard - Thank - you very much for your help.

-----Original Message-----
Rik wrote :


Let's say in cells A2:A20 you have the names of the employees, and in B2:B20
the date corresponding to their first day in employment.

Select cell A2. In the "Format" Menu, select

the "Conditional Formatting..."

item, thus opening a pop-up Window.

In this Window, toggle the first field to "The formula is".

In the next field, type: "=B2<(NOW()-30)" (without the quotes)

Now, click the "Format..." button, and set the format you want to see when
this condition is filled (Bold Font, Red Background...)

Click the "OK" button. Copy the cell. Select cells A3:A20 and "Paste
Special..." from the "Edit" Menu, having the "Format" button checked.

The names in Col A should come out as expected when the employees are in
employment for more than 30 days now. If this doesn't give the expected
results, let us know from what point it seems to go wrong,


---------------------------------------------------------
Please reply to the newsgroup, and within the same thread.
Merci de répondre au groupe, et dans l'enfilade.

--
Bernard Rey - Toulouse / France
MVP - Macintosh


Rik wrote :

-----Original Message-----
Could someone help me create a formula a spreadsheet.

I would like a formula that would flag up, when an
employee has been in employment for over a month for their
induction.

Cheers

Rik, I have no idea what "flag up" means, but check into
conditional formatting.

--
Bob Greenblatt [Excel MVP]
(e-mail address removed)
www.bandlassoc.com


Bob

what I mean by Flag Up, is that when an employee has been
in traing for over a month, i would like the employee's
name to be highlighted, or change colour on the name.

Regards
.

You can do this with a macro. Or, if you have another column next to the
name for your flag, you can enter a formula that computes the time in
training. And, when it exceeds a certain value the cell will highlight via
conditional formatting of the cell.

.