CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaconditional-formatting
Ali Ahmed
Ali Ahmed

Reputation: 155

Multi conditional formatting not working in google sheets. only 3 steps working

What I am trying to do here,

  1. If a cell value AA=>7 the whole row will be "Orange": This is working
  2. If a cell value AA=>10 the whole row will be "Red": This is working
  3. If another cell V="Cancelled" it will override conditional formatting 1 and 2 the whole row will be white, Red text, and strikethrough: This is working
  4. if same "V" cell V="Shipped" the whole row should be Green and conditional formating 1 2 and 3 will be overridden: This is not working

This is what I did in the Google Sheets

Upvotes: 1

Views: 1567

Answers (1)

NightEye
NightEye

Reputation: 11214

You should add a condition on your 1 and 2 conditions to prevent them from overwriting the failing condition and not interfere with each other

=AND($AA2>=7, $AA2<=9, $V2<>"Shipped")

=AND($AA2>=10, $V2<>"Shipped")

This means that they only format the cells IF $V2 is not "Shipped" and condition 1 will only work on AA values 7-9

The problem with your conditions is that it can support 2 cases at once. For these issues, we need to completely separate them so that they will not have issues.

Every case should only be under 1 conditional formatting for it to work properly.

sample data

Also, note the hierarchy of the conditions as it will affect the outcome.

Reference:

Upvotes: 1

Related Questions