the true condition and color if condition is True.
> Actually this is no only F7 once we apply in all range this will change the
> F7 to F8, F9, F10 ,F11
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Ganesh N
>
Subject: 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)
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
=$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
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