Solved

Conditional Format in Excel

Posted on 2014-01-26
7
421 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
7 Comments
 
LVL 8

Expert Comment

by:itjockey
ID: 39811045
Hi AXISHK,

See attached
Formatting.xlsx
0
 
LVL 8

Accepted Solution

by:
itjockey 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:itjockey
ID: 39811063
After Step 5 Copy format & past to desire range.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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:itjockey
ID: 39811073
Thank you Sir......I am disciple of yours....  :)
0
 

Author Comment

by:AXISHK
ID: 39811152
Tks.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
location range 4 22
Struggling to Lock and grey out cells using VBA. Help please! 8 23
FormulaArray VBA Issue 6 17
Manually enter date in datepicker 24 30
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

914 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now