Forum Discussion

stever78's avatar
stever78
Brass Contributor
Sep 19, 2021
Solved

Conditional Formatting not responding

Hi, In Excel.

When i select anything from conditional formatting excel just hangs.

it doesn't do anything and i cant use it, nothing responds.

i dont get any any error message and it doesnt going into any "official" not responding in task manager.

 

this happens to any worksheet or even to a new worksheet.

 

Does anyone know if there is a fix to this or do i have to re-install excel?

 

anything in options/account i need to do

 

excel 365

 

many thanks for your help

 

steve r

  • ok thanks. i needed to remove all ADD-INS and then do the office quick repair tool.
    this fixed the issue, thanks
  • stever78's avatar
    stever78
    Brass Contributor
    ok thanks. i needed to remove all ADD-INS and then do the office quick repair tool.
    this fixed the issue, thanks
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    stever78 

     

    Conditional formatting compatibility issues

    The Compatibility Checker found one or more conditional formatting-related compatibility issues.

    Important: Before you continue saving the workbook to an earlier file format, you should address issues that cause a significant loss of functionality so that you can prevent permanent loss of data or incorrect functionality.

     

    Hope I was able to help you with this info.

     

    NikolinoDE

     

    Was the answer useful? Mark them as helpful!

    This will help all forum participants.

  • Yea_So's avatar
    Yea_So
    Bronze Contributor
    try doing a reinstall, if that still does not help then do a reinstall with the scrub.exe from Microsoft 365

Resources