Conditional Formatting keeps changing alignment

Black Arrow

New Member
Joined
Dec 1, 2020
Messages
13
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
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
11,900
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
13
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,303
Messages
5,595,324
Members
413,986
Latest member
Elizsk

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