Conditional Formatting keeps changing alignment

Black Arrow

New Member
Joined
Dec 1, 2020
Messages
39
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Hi, I have simple to do list in a table with one rule in Conditional Formatting. If the text within cells D5:D19 are changed to "Completed", the entire row should color green. Somehow once the Conditional Formatting is applied the alignment is also changed. I already tried to save the Excel file in a different format (.xls, .xlsm, etc.), but it doesn't change anything.

1.PNG 2.PNG
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
14,786
Office Version
  1. 365
Platform
  1. Windows
Usually when that happens it is down to the rule being set up against a row lower down the sheet.

When you set up the rule make sure that the top left cell of the range is active and base any formulas on that cell.
 
Solution

Black Arrow

New Member
Joined
Dec 1, 2020
Messages
39
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Usually when that happens it is down to the rule being set up against a row lower down the sheet.

When you set up the rule make sure that the top left cell of the range is active and base any formulas on that cell.
Thanks, this did the trick!
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,836
Messages
5,855,912
Members
431,774
Latest member
WillWilco

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