Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.00 seconds.

  1. Replies
    4
    Views
    226

    Re: Auto Hide Blank Cells

    ok, any idea how i can add some sort of conditional format to the cells then? so if they are blank then they have no border or background colour etc
  2. Re: Highlighting Cells with Conditional formatting

    scrap that i know the issue. when i was putting the formula in i was putting =$K$10 instead of =$K10. it is working now. brilliant thanks.
  3. Re: Highlighting Cells with Conditional formatting

    it isnt working on mine. it is just highlighting all of them when the top site matches the drop down.

    my drop down is in cell D7.
    the table i have is in J9 (headers) to L21.

    i am highlighting...
  4. Re: Highlighting Cells with Conditional formatting

    Hi this isnt working. it isnt highlighting any of the info now? would the B2 reference part not only highlight everything is the item in B2 matches what is in the drop down?
  5. Highlighting Cells with Conditional formatting

    i currently have a couple of tables on a workbook. i am wanting to use some conditional formatting that will highlight certain cells when a criteria is met and will change the highlighted cells when...
  6. Replies
    4
    Views
    226

    Re: Auto Hide Blank Cells

    anyone help with this?
  7. Thread: Countifs

    by jwgreen1986
    Replies
    10
    Views
    403

    Re: Countifs

    another two threads if you can help haha

    https://www.mrexcel.com/forum/excel-questions/1098414-conditional-formatting.html...
  8. Replies
    1
    Views
    144

    Conditional formatting

    just a little help needed.

    3 tables on one worksheet that change depending on what is selected from drop downs. is it possible to look up the values from the first table (sales for advisers at a...
  9. Replies
    4
    Views
    226

    Auto Hide Blank Cells

    I currently have 3 different tables on one sheet.

    a table that lists the standings of sale execs at a certain site.
    another that has the standings of all the sites
    a final one that has the...
  10. Thread: Countifs

    by jwgreen1986
    Replies
    10
    Views
    403

    Re: Countifs

    Absolutely Fantastic. this is now working fab. brilliant thanks.
  11. Thread: Countifs

    by jwgreen1986
    Replies
    10
    Views
    403

    Re: Countifs

    Hi thanks for the reply.
    tried the formula to generate the number. got a #Value error
    ...
  12. Thread: Countifs

    by jwgreen1986
    Replies
    10
    Views
    403

    Re: Countifs

    so what i want this table to do is
    when i select New on the drop down from my standings tab (Standings!$D$5) it will list all the staff at the chosen site that are either on the New scheme or...
  13. Thread: Countifs

    by jwgreen1986
    Replies
    10
    Views
    403

    Re: Countifs

    Hi,

    can you explain the formulas a little more. i understand the helper bit and what you are doing, just not the formula in there. it looks to me like it is just looking at the "Overall" option in...
  14. Thread: Countifs

    by jwgreen1986
    Replies
    10
    Views
    403

    Re: Countifs

    hi thanks,

    however i dont want it to actually tell me how many sales there has been at the site, i want it to list the people at site. This is the little table i have at the min. the formula i use...
  15. Thread: Countifs

    by jwgreen1986
    Replies
    10
    Views
    403

    Countifs

    Having a lot of issues trying to resolve this problem.
    so i currently have 3 league tables. each league table is then automatically changed depending on the options selected from some drop downs.
    ...
  16. Replies
    4
    Views
    163

    Re: SUM IF - 2 Different tables

    so i worked out what you meant and have it sorted. thank you very much
  17. Replies
    4
    Views
    163

    Re: SUM IF - 2 Different tables

    Hi, is the employee1 and 2 the names of the tables?

    for easiness i have two ranges set up in excel. one called NT the other UT. each of these have 4 columns each. name, site, scheme, sales.
    i...
  18. Replies
    4
    Views
    163

    SUM IF - 2 Different tables

    I am wanting to sum two totals if possible. I have a used sale section and a new sale section. These are both separate for other reasons and reports.
    However i am trying to now create a new section...
  19. Replies
    1
    Views
    135

    Re: Auto update a filter

    up date on this, i have been given VBA codes to put in but these then mess around with the drop downs. so i have used the below, but when i then change the drop down it doesnt update the table with...
  20. Replies
    1
    Views
    135

    Auto update a filter

    i currently have a league table on a spreadsheet. a drop down lets you change certain things that will show in the league table (sales type, month etc)
    the league table is working fine and...
  21. Replies
    1
    Views
    213

    Auto Calculate - VBA

    does anyone know the VBA code to recalculate a sheet when a change to a drop down is made?
    i have a huge amount of calculations in other worksheets so dont want to turn on the automatic workbook...
  22. Replies
    5
    Views
    180

    Re: Automatically updating a filter

    Brilliant,

    thanks this is now working beautifully
  23. Replies
    5
    Views
    180

    Re: Automatically updating a filter

    so with the code you have supplied, is it a case of changing the sheet1 to that my sheet is called and then that is it?
  24. Replies
    7
    Views
    158

    Re: #Name? error

    You any good with filters?

    https://www.mrexcel.com/forum/excel-questions/1091618-automatically-updating-filter.html
  25. Replies
    7
    Views
    158

    Re: #Name? error

    i did not know this.
Results 1 to 25 of 62
Page 1 of 3 1 2 3