RE: $$Excel-Macros$$ Request help on conditional formatting

NAME AMT FORMULA RESULT (TRUE/FALSE) Ganesh 20 =$F7=MAX($F$7:$F$11) FALSE Guna 90 =$F8=MAX($F$7:$F$11) TRUE Karthick 30 =$F9=MAX($F$7:$F$11) FALSE Kumar 50 =$F10=MAX($F$7:$F$11) FALSE Senthil 40 =$F11=MAX($F$7:$F$11) FALSE This will check the true condition and colo

Re: $$Excel-Macros$$ Request help on conditional formatting

Thanks Ravinder!!! Ravinder may i know why we are using $F7 ? before =Max. Else can you explain how it works ? Thanks & Regards Ganesh N On Mon, Feb 10, 2014 at 10:16 AM, Ravinder wrote: > =$F7=MAX($F$7:$F$11) try this formula in condition formatting option or > pfa > > > > *From:* excel-macr

Re: $$Excel-Macros$$ Add Section A to D

Students_Marks.xlsx Dear Ashish, Please find the sample file Thanks, Kathir On Sat, Feb 8, 2014 at 8:33 PM, ashish koul wrote: > please share sample file > > > On Sat, Feb 8, 2014 at 5:34 PM, KATHIRVELAN N wrote

Re: $$Excel-Macros$$ Matching Total of pair

> > my logic is colom a amount sum match with c colom > 1 example. : a2 amount is 1068190/- ref .1 match with c colom amounts > 62226,16094,7066,191520,367764,423520 total = 1068190/- and ref.1 write > in colom d > 2 example. : a3 amount is 351971/- ref. 3match with c colom amounts 151972

RE: $$Excel-Macros$$ Request help on conditional formatting

=$F7=MAX($F$7:$F$11) try this formula in condition formatting option or pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ganesh N Sent: Sunday, February 09, 2014 9:16 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Request help on condi

Re: $$Excel-Macros$$ Matching Total of pair

Not understanding the You see the File 2014-02-09 13:18 GMT+07:00 kartikey patel : > Dear, > > I want a2 colom amount match c2 : c7 total > > See this attached file to i want it. > > Thanks > Kartik > > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's > =TIM

Re: $$Excel-Macros$$ Request help on conditional formatting

Choose E7: E20, Condition 1: Cell Value Is selected, the right pane is used Formula function: = F7: F20> 50 Click the Format button to select the color 2014-02-09 22:45 GMT+07:00 Ganesh N : > Hi team, > > Any one can help me to know how to highlight the name based on other > column value (need

$$Excel-Macros$$ Request help on conditional formatting

Hi team, Any one can help me to know how to highlight the name based on other column value (need to highlight name based on the highest or lowest value of other column). Please find sample example has been attached. Thanks & Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? A

Re: $$Excel-Macros$$ saved JSON formats to EXCEL

http://ramblings.mcpher.com/Home/excelquirks/json On Sun, Feb 9, 2014 at 10:41 AM, yogananda muthaiah < yogananda.mutha...@gmail.com> wrote: > Hi > > can Anyone give a solution to this > > > On Sat, Feb 8, 2014 at 5:01 PM, yogananda muthaiah < > yogananda.mutha...@gmail.com> wrote: > >> >> Hi,