Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 2nd 08, 12:01 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2008
Posts: 2
Default 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.

  #2   Report Post  
Old April 2nd 08, 08:39 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 345
Default 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.

  #3   Report Post  
Old April 8th 08, 09:02 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2008
Posts: 2
Default Desperately in need of some help

On Apr 2, 3:39*am, [email protected] 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Desperately need a command or something! mitch phelps Excel Discussion (Misc queries) 5 February 2nd 08 08:03 AM
DESPERATELY NEED HELP newuser Excel Discussion (Misc queries) 3 November 2nd 07 04:02 PM
Desperately need help!! Paula_p New Users to Excel 1 June 13th 06 10:26 PM
Desperately need help with 3 calculations Scoooter Excel Worksheet Functions 3 June 12th 06 04:28 PM
Desperately need help!!! Pivot table TotallyConfused Excel Discussion (Misc queries) 3 March 8th 06 09:08 PM


All times are GMT +1. The time now is 09:45 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017