Desperately in need of some help
 

I am trying to automate what has been a manual process. The assumption
was that the app that we get the data from could not export to
something that excel or access could use. The app can output the data
and so I would like to use excel to do a couple of things. This is for
excel 2003.

First, I need to highlight a row based on the value in one cell. I
have tried the conditional formatting but all I get is the A column
cell with the highlight even if I have selected A5:H5 I have tried to
test for the value in a cell or the result of a formula with the same
results.

The second thing I would like to do is copy values to a second sheet
within the same workbook. The second worksheet would detail absence
for a year and would look at 3 types of leave. I understand that I
would have to somehow test that the date in column 1 of sheet 1 is
(greater than or equal to Jan 1and less than or equal to Dec 31) AND
(hat the value in column F="Cert"). I get that I would have to repeat
that for the years that are desired and for the different types of
absence. What I don't get is how to do it.

Is this even possible in Excel? Do I need to use Access instead? I am
reasonable computer savvy but not great on Excel.

Appreciate any help I can get! Thank you.

Desperately in need of some help
 

Conditional formatting:
Assume value to trigger format is in column A
In A1 to enter your Conditional Format - change to 'Formula is'
=$A1=whatever your value is
And the format you require. Test with your value in A1. If OK, copy across
columns (using a single row) as far as you require. Now copy that row down as
far as you require.
Now when you enter 'your value' in column A, the complete row will reflect
your format.
Your second problem requires more clarification to identify a solution.


"perfj" wrote:

I am trying to automate what has been a manual process. The assumption
was that the app that we get the data from could not export to
something that excel or access could use. The app can output the data
and so I would like to use excel to do a couple of things. This is for
excel 2003.

First, I need to highlight a row based on the value in one cell. I
have tried the conditional formatting but all I get is the A column
cell with the highlight even if I have selected A5:H5 I have tried to
test for the value in a cell or the result of a formula with the same
results.

The second thing I would like to do is copy values to a second sheet
within the same workbook. The second worksheet would detail absence
for a year and would look at 3 types of leave. I understand that I
would have to somehow test that the date in column 1 of sheet 1 is
(greater than or equal to Jan 1and less than or equal to Dec 31) AND
(hat the value in column F="Cert"). I get that I would have to repeat
that for the years that are desired and for the different types of
absence. What I don't get is how to do it.

Is this even possible in Excel? Do I need to use Access instead? I am
reasonable computer savvy but not great on Excel.

Appreciate any help I can get! Thank you.

Desperately in need of some help
 

On Apr 2, 3:39*am, Ron@Buy wrote:
Conditional formatting:
Assume value to trigger format is in column A
In A1 to enter your Conditional Format - change to 'Formula is'
=$A1=whatever your value is
And the format you require. Test with your value in A1. If OK, copy across
columns (using a single row) as far as you require. Now copy that row down as
far as you require.
Now when you enter 'your value' in column A, the complete row will reflect
your format.
Your second problem requires more clarification to identify a solution.



"perfj" wrote:
I am trying to automate what has been a manual process. The assumption
was that the app that we get the data from could not export to
something that excel or access could use. The app can output the data
and so I would like to use excel to do a couple of things. This is for
excel 2003.

First, I need to highlight a row based on the value in one cell. I
have tried the conditional formatting but all I get is the A column
cell with the highlight even if I have selected A5:H5 I have tried to
test for the value in a cell or the result of a formula with the same
results.

The second thing I would like to do is copy values to a second sheet
within the same workbook. The second worksheet would detail absence
for a year and would look at 3 types ofleave. I understand that I
would have to somehow test that the date in column 1 of sheet 1 is
(greater than or equal to Jan 1and less than or equal to Dec 31) AND
(hat the value in column F="Cert"). I get that I would have to repeat
that for the years that are desired and for the different types of
absence. What I don't get is how to do it.

Is this even possible in Excel? Do I need to use Access instead? I am
reasonable computer savvy but not great on Excel.

Appreciate any help I can get! Thank you.- Hide quoted text -

- Show quoted text -

Ron, I apologize for the delay in getting back to you. I was yanked
quite suddenly away from town. I should be able to try your suggestion
in a couple of days. As for the second part, I think that the
organization may be acquiring new software to do leave analytics,
which I enthusiastically support.

Thanks again.