Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / October 2006

Tip: Looking for answers? Try searching our database.

CONDITIONAL FORMATS

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
romelsb - 21 Oct 2006 20:37 GMT
Can anybody tell me other limitations of formula that can be absorbed in a
conditional format window wherein a cell change color based on logical
conditions (e.g. 7 "IF"s,), search functions like lookups, etc....please give
awareness...
daddylonglegs - 21 Oct 2006 21:32 GMT
In general you can use any formula that returns a TRUE/FALSE result, although
there are some limitations, e.g. you can't directly refer to other
worksheets, or use Analysis ToolPak functions are use array constants like
{1,2,3}.

Do you have a specific need?

> Can anybody tell me other limitations of formula that can be absorbed in a
> conditional format window wherein a cell change color based on logical
> conditions (e.g. 7 "IF"s,), search functions like lookups, etc....please give
> awareness...
romelsb - 21 Oct 2006 21:54 GMT
tks for the reply...I do need this in my work...Cost vs Date vs Quantity of
our  project scheduling that must re-adjust every month upon encoding of
current quantity and remaining quantity, that will be distributed within a
re-adjusted Date of finish. The colors must cope up with the adjusted dates
as well as if the actual qty. has been consumed completely, and the cost as
well <these 3 has 2 conditions each> in order to change the cell
color/borders  based on a legend that will be printed for project's monthly
presentation. This is a one sheet of excel.

> In general you can use any formula that returns a TRUE/FALSE result, although
> there are some limitations, e.g. you can't directly refer to other
[quoted text clipped - 7 lines]
> > conditions (e.g. 7 "IF"s,), search functions like lookups, etc....please give
> > awareness...
romelsb - 21 Oct 2006 22:05 GMT
Thanks... I hope there will be improvements...i do need such in reference to
3 cell whose independent values varies in relation to Date, monthly, for a
printed presentation. Thanks and more power....

> In general you can use any formula that returns a TRUE/FALSE result, although
> there are some limitations, e.g. you can't directly refer to other
[quoted text clipped - 7 lines]
> > conditions (e.g. 7 "IF"s,), search functions like lookups, etc....please give
> > awareness...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.