+ Reply to Thread
Results 1 to 10 of 10

Conditional formatting stopped working

  1. #1
    Registered User
    Join Date
    02-09-2010
    Location
    knottingley england
    MS-Off Ver
    Office 365 Excel
    Posts
    53

    Conditional formatting stopped working

    I have been using the attached file which I constructed a couple of years ago with help from this forum. It has worked perfectly until I transferred it to another computer. Everything works apart from the conditional formatting which turns the numbers red when they have been selected. Any help would be appreciated
    Regards Troysie
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Conditional formatting stopped working

    Hi Troysie,

    What are the numbers or cells which should turn to Red when selected?

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    02-09-2010
    Location
    knottingley england
    MS-Off Ver
    Office 365 Excel
    Posts
    53

    Re: Conditional formatting stopped working

    when the numbers are entered in the top box all the same numbers in the bottom box should turn red.when six numbers turn red in one line that persons name will turn green
    regards John

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Conditional formatting stopped working

    Hi John,

    First part is done. please check and let me know if that is fine so that I can proceed with second part. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-09-2010
    Location
    knottingley england
    MS-Off Ver
    Office 365 Excel
    Posts
    53

    Re: Conditional formatting stopped working

    thank you that is what I need,but I cannot get it to accept any more numbers
    regards Troysie

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Conditional formatting stopped working

    Ok..

    What numbers are not getting accepted there.. can you explain using sample file?

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  7. #7
    Registered User
    Join Date
    02-09-2010
    Location
    knottingley england
    MS-Off Ver
    Office 365 Excel
    Posts
    53

    Re: Conditional formatting stopped working

    sorry the numbers are being accepted ,it was just that it was working very slowly
    regars John

  8. #8
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Conditional formatting stopped working

    Ok.. so with that confirmation, I have completed the second part as well.. please see the attached file. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    02-09-2010
    Location
    knottingley england
    MS-Off Ver
    Office 365 Excel
    Posts
    53

    Re: Conditional formatting stopped working

    Thank you that works perfectly
    regards Troysie

  10. #10
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Conditional formatting stopped working

    You are welcome John (troysie)...

    cheers


    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ Reply to Thread

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