Search:

Type: Posts; User: Remburg; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    99

    Re: Color coded schedule

    Update:

    I realized I made some true rookie mistakes which I blame my tiredness.

    Following code worked:

    Function GetColorCount(CountRange As Range, CountColor As Range, CountColor2 As...
  2. Replies
    2
    Views
    99

    Color coded schedule

    Hello,

    I am working on a schedule for work at this moment. I am using a range of colors, however, I wish that when I put green color on a person I wish it to count as a 1 FTE resource, and if I...
  3. Replies
    5
    Views
    137

    Re: Which cells is not true

    The point is that I want the output to show a reference to the specific cell(s).
  4. Replies
    5
    Views
    137

    Re: Which cells is not true

    Yeah, i might have been unclear. I have =if(and()) functions that checks if all of the sum rows are positive. What I am looking for is if a formula could produce a new table where the output shows...
  5. Replies
    5
    Views
    137

    Which cells is not true

    The spreadsheet contains information about articles and prizes which has been set up with =if functions. What I am looking for now is if there is a possibility to create a table where excel shows me...
Results 1 to 5 of 5