I have been told that I can add a tickmark toolbar to excel.

Hello Friends
i have a flat database in excel
i want to know how can i color the fonts based on the cell value
say eg

I used Get.Workbook(1) and derived an array of all worksheets' names
(eg. wsNames). When I try to put it as a list in Data Validation
(=wsNames) I get an error.
Also: Cant get complete reference about these Get.xxx(x)  anywhere.

I currently have a function that I would like to tweak a little.
Here is the scenario:
Example:    Actual Hours    Total       Comptime       Overtime
                       AE              AJ            AL                 AM

Is there a good source to really learn how to use this commands in formulas.  
I see and have also been helped by you folks with using these commands, but I
can not seem to get a grasp on the right way to use them when I am trying to
put a formula together.

Given that column E lists an "Available Amount", and column F lists an
"Average Amount", I want the following result in column G:
IF "Available Amount"=0, then "Complete", else, "Available Amount"/"Average
Amount" OR IF "Average Amount"=0, then "Not started", else, "Available

I would like to create a lookup formula that will return info in the cells
adjacent to the cell with the info in the lookup, is this possible?

I created a keypad (similar to a phone or ATM numbers 0-9).  When you
click on a number key, that key populates a matrix (via macro) similar
to:
All Numbers            Numbers Clicked

I have a daily reporting system in which I have a macro to make a new sheet
as well as clear some information from the previous sheet in a workbook with
muliple sheets of different names besides DR(1) etc. Since the number of days
per job is variable, I need to add something into ...

Anyone know how to remove the formula and leave the data?
I filled a column A3 with an IF(B3="",C3,B3).  Now I want to remove the IF
function but leave the data that was replaced.
Tks,

I'm wondering if there is a way to take a list numbers which are in
multiple columns and put them into order in one column?
Sample data:
1........6..........11

I have used the VLookup function on an invoice that will print the price and
description of an item when the item number is typed in. I want to removed
the #N/A from the invoice when the lines are blank. I was told to use the IF
function.

I have a table of several columns of information.  In one column there
is an invoice number.  In another column the amount for that line of
the invoice.  If there are multiple lines for that invoice, there are
multiple rows in the table with the same invoice number.

I'm trying to use vlookup with multiple worksheets defined by a dynamic
table_array value.  I can store the appropriate value in a cell with the
correct format, but the vlookup function returns a REF error.
Example:

I have a worksheet that displays appt. time & actual time in, some of my
actual time in data is greater than the appt. time ex: 13:15 appt time,
Actual time in 13:18, the cell should show :03 in red? but instead it gives
me a #VALUE!. How can I display this time, and show it as a ...