Solved

Excel Conditional Format

Posted on 2014-02-06
4
221 Views
Last Modified: 2014-02-09
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
Comment
Question by:AXISHK
  • 2
  • 2
4 Comments
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 39841236
Hi,

you could use =B2<C2

Regards
Templatev1.xlsx
0
 

Author Comment

by:AXISHK
ID: 39841334
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
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39841491
Hi,

You have =R3<S3

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

Regards
0
 

Author Closing Comment

by:AXISHK
ID: 39846207
Tks
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question