Excel Conditional Formatting with Formula

Question

I want to highlight cells in column A whose corresponding values in column B meet a certain criteria. I followed some ways but none leaded to anything. I just want to highlight cells in column A whose values in column B are greater than 100.

user4039065 · Accepted Answer · 2018-04-14 06:25:39Z

1

Select column A with A1 as the active cell then create a CFR based on the following formula.

=and($b1>100, row()>1)

answered Apr 14, 2018 at 6:25

user4039065

Sign up to request clarification or add additional context in comments.

2 Comments

Fighter Jet Over a year ago

Could you explain the reason why you added the second condition: row()>1 ?

user4039065 Over a year ago

You have text as column header labels and I didn't want any confusion.

Collectives™ on Stack Overflow

Excel Conditional Formatting with Formula

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related