Results 1 to 6 of 6

Change formula to work in conditional formatting

Threaded View

efernandes67 Change formula to work in... 01-02-2011, 06:39 PM
DonkeyOte Re: Change formula to work in... 01-03-2011, 04:36 AM
efernandes67 Re: Change formula to work in... 01-03-2011, 06:08 AM
efernandes67 Re: Change formula to work in... 01-03-2011, 06:45 PM
efernandes67 Re: Change formula to work in... 01-03-2011, 07:17 PM
DonkeyOte Re: Change formula to work in... 01-04-2011, 03:06 AM
  1. #1
    Registered User
    Join Date
    01-01-2005
    MS-Off Ver
    2007
    Posts
    368

    Change formula to work in conditional formatting

    Hi,

    I have the following code that is working ok

    {=SUM((tbPlanner[Name]="Orlando")*(tbPlanner[sDate]<=E24)*(tbPlanner[eDate]>=E24))}
    I need to change so that I can use it in conditional formatting.

    I tried to use INDIRECT but I am having some problems because I am not used to work with it. I' ve been thinking to use COUNTIFS instead of SUM.

    Any help would be great!

    Regards,
    Elio Fernandes
    Attached Files Attached Files
    Last edited by efernandes67; 01-03-2011 at 06:46 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1