[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 435
  • 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
Industry Leaders: 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!

 
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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