Updated attached.
On Wed, May 8, 2013 at 12:33 PM, Chaya wrote:
> Abhishek sir,
>
>The second solution provided to me is fine but-
> firstly - if i put 2 then all the number greater than 2 will mark as red,
> again while putting 5 than it will also mark as red as well 2 also,
>
>genera
Abhishek sir,
The second solution provided to me is fine but-
firstly - if i put 2 then all the number greater than 2 will mark as red,
again while putting 5 than it will also mark as red as well 2 also,
generally only 5 should be mark as red not 2 while putting 5 in M2 cells.
Hope you un
Thank you very very much Abhishek Sir And Priti mam.
Once again thank you very much for the solution.
Regards,
Chaya
Regards,
Chaya
On Wed, May 8, 2013 at 12:12 PM, priti verma wrote:
> try this
>
> Sub Highlighting_cell()
>
> Dim rngCell As Range
> Dim rngRange As Range
>
try this
Sub Highlighting_cell()
Dim rngCell As Range
Dim rngRange As Range
Set rngRange = Intersect(Sheet1.Range("a1").CurrentRegion,
Sheet1.Range("a1").CurrentRegion.Offset(1, 1))
For Each rngCell In rngRange
If rngCell.Value > 2 Then
rngCell.Font.Color =
On Wed, May 8, 2013 at 11:33 AM, Chaya wrote:
> Dear Experts,
>
> Please help me in highting number which is greater than 2 by excel vba in
> red colour.
> from B2: F12 range.
>
> Thanks
>
> Regards,
>
> Chaya
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =
Updated as per revised requirement.
On Wed, May 8, 2013 at 12:04 PM, Chaya wrote:
> Dear Experts,
>
> Please help me in highlight number which is greater than 2 by excel vba
> in red colour.
> from B2: F12 range.
>
> Please find the attachment.
>
> Small changes, in Attached file in M2 cell, wh
Here.
On Wed, May 8, 2013 at 11:33 AM, Chaya wrote:
> Dear Experts,
>
> Please help me in highting number which is greater than 2 by excel vba in
> red colour.
> from B2: F12 range.
>
> Thanks
>
> Regards,
>
> Chaya
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? I
Dear Experts,
Please help me in highlight number which is greater than 2 by excel vba in
red colour.
from B2: F12 range.
Please find the attachment.
Small changes, in Attached file in M2 cell, whatever the value i will put
the same value greater than its value should highlight it.
Example :
if
