+ Reply to Thread
Results 1 to 2 of 2

Conditional format table based on 2 columns & lock hide old data rows but allow new rows

  1. #1
    Forum Contributor
    Join Date
    09-02-2014
    Location
    England
    MS-Off Ver
    2013
    Posts
    116

    Conditional format table based on 2 columns & lock hide old data rows but allow new rows

    Hi

    I have a table of private info that I would like someone to work on. Basically they need to add new rows of new unique venues completing all columns.

    Firstly I want the row 11 and onwards to change colour if the text in column a and b both contain duplicates ie in the attached example row 11 would appear in a different colour as it contains both birmingham and roadhouse even though its doesnt contain the full duplicate " The Roadhouse".

    Secondly I want to lock and hide all previous data ie rows 2- 10 so the user can only see there own entries but still be alerted by conditional formatting if their entry is a duplicate or not

    CDan anyone help - having difficulty attaching the doc?

    Dave
    Attached Files Attached Files
    Last edited by faodavid; 05-24-2016 at 01:01 PM.

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL (COVID allowing)
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,383

    Re: Conditional format table based on 2 columns & lock hide old data rows but allow new ro

    To attach a file, click 'Go Advanced' then scroll down and click 'Manage Attachments'.
    Regards,
    Aardigspook

    Recently moved house, internationally, during COVID (!) so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hide Rows/Hide Columns Based on Value in Cell
    By brickwall823 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2015, 02:42 PM
  2. Need help creating macro to hide rows based upon whether 1 of 3 rows have data
    By BigEdJr in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-17-2014, 02:58 PM
  3. NEED IMMEDIATE HELP - Auto-Hide Rows Based on Data in two columns
    By DLavoie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2013, 12:58 PM
  4. [SOLVED] Conditional format to hide 0 w Odd,Even rows highlighted.
    By JO505 in forum Excel General
    Replies: 4
    Last Post: 03-03-2013, 08:19 PM
  5. [SOLVED] Macro to Conditional Format Columns A:F, Rows 3:end of data
    By Gard5096 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-21-2013, 12:09 PM
  6. Macro to hide both rows and columns simultaneously based on data in cells.
    By walker_dp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2012, 10:47 AM
  7. Conditional Formatting to Hide Rows or Columns?
    By sczegus in forum Excel General
    Replies: 4
    Last Post: 10-03-2006, 10:15 AM

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