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?
 
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
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
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
All Courses

From novice to tech pro — start learning today.