Excel Conditional Format

How to configure a conditional format on the attached worksheet such than any value in column B will be highlighted if it's value is smaller than that in Column C

Tks
Template.xlsx
AXISHKAsked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

You have =R3<S3

but it should be =R2<S2 because the range begins at Row 2

Regards
0
 
Rgonzo1971Commented:
Hi,

you could use =B2<C2

Regards
Templatev1.xlsx
0
 
AXISHKAuthor Commented:
Not sure what's wrong on my Excel. I have put the conditional format on Column R and compare the value on S2. However, it doesn't row the correct row.

Any idea ?

Tks
test.xlsx
0
 
AXISHKAuthor Commented:
Tks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.