?
Solved

Excel Conditional Format

Posted on 2014-02-06
4
Medium Priority
?
231 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 52

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 52

Accepted Solution

by:
Rgonzo1971 earned 2000 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

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

762 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