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 ?
AXISHKAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Naresh PatelConnect With a Mentor TraderCommented:
if you want to do it in your workbook then Step 1Step 2Step 3Step 4Step 5

Thanks
0
 
Naresh PatelTraderCommented:
Hi AXISHK,

See attached
Formatting.xlsx
0
 
Naresh PatelTraderCommented:
After Step 5 Copy format & past to desire range.
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
MINDSUPERBConnect With a Mentor Commented:
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.

All Courses

From novice to tech pro — start learning today.