Share via

Conditional Excel Formatting for multiple Rows and Columns

Anonymous
2023-03-02T14:42:40+00:00

I need help figuring out some conditional formatting, and can't seem to get this to work looking at conditional formatting based on both a column, row, and Cell value.

  • I have a large chart of formulas that determine when to put an X in a specific Cell. I want to highlight and conditional format that entire range.
  • I want to turn only the specific cells within the Range Red when both conditions below are true:
    • If the specific Cell within the range contains an X
    • AND if the value of column S only for that specific ROW is > 0
Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2023-03-02T14:57:26+00:00

    Please have a look into this article:

    Conditional Format - How to develop a formula (for beginners) - Microsoft Community

    If you need further help, we need to see your file.

    Andreas.

    Was this answer helpful?

    0 comments