Solved

Conditional Format in Excel

Posted on 2014-01-26
7
431 Views
Last Modified: 2014-01-26
How to format a cell in excel such that the cell  under Column W will be highlighted if it's  value is smaller than the corresponding value in Column X under the same row ?
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
7 Comments
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39811045
Hi AXISHK,

See attached
Formatting.xlsx
0
 
LVL 8

Accepted Solution

by:
Naresh Patel earned 350 total points
ID: 39811056
if you want to do it in your workbook then Step 1Step 2Step 3Step 4Step 5

Thanks
0
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39811063
After Step 5 Copy format & past to desire range.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 19

Assisted Solution

by:MINDSUPERB
MINDSUPERB earned 150 total points
ID: 39811065
The tutorial on the link below would give you a good grasp as well with conditional formatting.

http://office.microsoft.com/en-001/excel-help/use-a-formula-to-apply-conditional-formatting-HA102809768.aspx

Sincerely,

Ed
0
 
LVL 81

Expert Comment

by:byundt
ID: 39811070
itjockey,
I was going to bust your chops for posting a workbook without any supporting discussion in your first Comment--but then I saw all the screenshots in your second Comment.

Nicely done!

Brad
0
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39811073
Thank you Sir......I am disciple of yours....  :)
0
 

Author Comment

by:AXISHK
ID: 39811152
Tks.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

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…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
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…

695 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