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)
gt;
> *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 conditional formatting
>
>
>
> Hi te
=$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
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
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
