range color from date and database

[ilaboo]

newbie
done some homework on excel


i would like to have a range change color based on date and time and a
name from a database--or any suggestion



for example if it is thursday and the time is betweeen 1 and 3 pm i want
the range to be say light red

if out of tinme range i want it to be light green


also the cell above the range as long as time constraints are met
to have a name from a datasource


any suggestions or ideas apprciated

i need to have data from either a database or from say another sheet
where user can enter a form

the data from the datasource would fill range values and a drop down
combobox



when user enters the application i want a spashscreen ( i know how to do
this) with various buttons

the buttons will either launch the woorkbook or a form for filling in data

any suggestions are appreciated

( incidently as i fill out this email the solutions seem to be in sight
and it might not be that hard to do)

 

[Frank Kabel]

Hi
have a look at 'Format - Conditional format'. See:
http://www.contextures.com/xlCondFormat01.html
http://www.cpearson.com/excel/cformatting.htm

 

[JE McGimpsey]

Look up "Conditional Formatting" in XL Help.