• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 441
  • Last Modified:

Conditional Format in Excel

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
AXISHK
Asked:
AXISHK
2 Solutions
 
Naresh PatelTraderCommented:
Hi AXISHK,

See attached
Formatting.xlsx
0
 
Naresh PatelTraderCommented:
if you want to do it in your workbook then Step 1Step 2Step 3Step 4Step 5

Thanks
0
 
Naresh PatelTraderCommented:
After Step 5 Copy format & past to desire range.
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
MINDSUPERBCommented:
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
 
byundtCommented:
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
 
Naresh PatelTraderCommented:
Thank you Sir......I am disciple of yours....  :)
0
 
AXISHKAuthor Commented:
Tks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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