[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 243
  • Last Modified:

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
0
AXISHK
Asked:
AXISHK
  • 2
  • 2
1 Solution
 
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
 
Rgonzo1971Commented:
Hi,

You have =R3<S3

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

Regards
0
 
AXISHKAuthor Commented:
Tks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now