Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i call a function to a cell?
Hi,
I am preparing an excel sheet and i am trying to make it carry out the following function. I have a dynamic list which has 3 entities (say A, B & C). Each entity represents a math formula say (Form1, Form2 & Form3) and each formula can reference up to 5 excel cells. Basically my question is, is it possible to pick an entity from the list which calls a formula and Illuminates the reference cells. I know it sounds complicated and i'm not sure if its a function or programming question but any help would be greatly appreciated Many Thanks, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i call a function to a cell?
If your list exists in say A1, then scroll down the reference cells you want
highlighted if they match. select FormatConditional Formatting: If Cell Value Is ------ equal to ------- $A$1 then set your format. whatever you pulled up off the list will show your match by formatting a cell in the "reference cells" HTH "Bill" wrote: Hi, I am preparing an excel sheet and i am trying to make it carry out the following function. I have a dynamic list which has 3 entities (say A, B & C). Each entity represents a math formula say (Form1, Form2 & Form3) and each formula can reference up to 5 excel cells. Basically my question is, is it possible to pick an entity from the list which calls a formula and Illuminates the reference cells. I know it sounds complicated and i'm not sure if its a function or programming question but any help would be greatly appreciated Many Thanks, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i call a function to a cell?
Conditional Formatting is a new function to me. Could you explain it a bit
more please? Thanks, Bill "ufo_pilot" wrote: If your list exists in say A1, then scroll down the reference cells you want highlighted if they match. select FormatConditional Formatting: If Cell Value Is ------ equal to ------- $A$1 then set your format. whatever you pulled up off the list will show your match by formatting a cell in the "reference cells" HTH "Bill" wrote: Hi, I am preparing an excel sheet and i am trying to make it carry out the following function. I have a dynamic list which has 3 entities (say A, B & C). Each entity represents a math formula say (Form1, Form2 & Form3) and each formula can reference up to 5 excel cells. Basically my question is, is it possible to pick an entity from the list which calls a formula and Illuminates the reference cells. I know it sounds complicated and i'm not sure if its a function or programming question but any help would be greatly appreciated Many Thanks, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i call a function to a cell?
I'd start with Debra Dalgleish's site:
http://contextures.com/xlCondFormat01.html Bill wrote: Conditional Formatting is a new function to me. Could you explain it a bit more please? Thanks, Bill "ufo_pilot" wrote: If your list exists in say A1, then scroll down the reference cells you want highlighted if they match. select FormatConditional Formatting: If Cell Value Is ------ equal to ------- $A$1 then set your format. whatever you pulled up off the list will show your match by formatting a cell in the "reference cells" HTH "Bill" wrote: Hi, I am preparing an excel sheet and i am trying to make it carry out the following function. I have a dynamic list which has 3 entities (say A, B & C). Each entity represents a math formula say (Form1, Form2 & Form3) and each formula can reference up to 5 excel cells. Basically my question is, is it possible to pick an entity from the list which calls a formula and Illuminates the reference cells. I know it sounds complicated and i'm not sure if its a function or programming question but any help would be greatly appreciated Many Thanks, -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Don't know what to call the type of function I need | Excel Worksheet Functions | |||
how can i call sub or function in vba code | Excel Discussion (Misc queries) | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
how i can call the function | Excel Worksheet Functions | |||
How to call a function from another workbook | Excel Discussion (Misc queries) |