Issue with conditional formatting

MissingInAction

Board Regular
Joined
Sep 20, 2019
Messages
62
Office Version
  1. 365
Platform
  1. Windows
Hi everyone
I'm having random issues with conditional formatting. Screenshot of the settings is attached.
I have the exact same settings on other cells with no issues. To clarify, the first condition's formula is =B13="termination"
If that cell has the word "termination", then I want B44 to B46 to be filled with white color and the other rule should not be processed. It is working perfectly for cell B44 and B45, but not B46. If I delete the rules and re-add them, it works as intended. If I then save and close the file and open it again later, some other conditional formatting rule in another cell is not working.
The second rule is simply if the cell is blank, it should be yellow.

Thank you
 

Attachments

  • Capture.PNG
    Capture.PNG
    11.2 KB · Views: 12

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

alz

Board Regular
Joined
Jul 17, 2020
Messages
130
Office Version
  1. 2019
Platform
  1. Windows
Lock your cell
$B$13= "Termination"
 
Solution

MissingInAction

Board Regular
Joined
Sep 20, 2019
Messages
62
Office Version
  1. 365
Platform
  1. Windows
I really don't understand why that worked, but it worked. Thank you.
I only really use the locking of formulas when I use autofil
 

Watch MrExcel Video

Forum statistics

Threads
1,127,373
Messages
5,624,309
Members
416,020
Latest member
ANDREAC247

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top