PLEASE SHARE SAMPLE FILE
On Thursday, May 14, 2015 at 3:24:47 PM UTC+5:30, ali abbas wrote:
> Dear All. Hope u r all well.
>
> I have two column with numbers. My requirement is if one column values is
> greater than other then greater values color should be red and its smaller
> values color is
Dear Santosh,
Please find the file, Hope this will help you..
On Sunday, March 24, 2013 2:09:41 PM UTC+5:30, santosh wrote:
>
> Hello Group,
>
> I need a way to highlight the amts that I can offset with each other based
> on the below conditions:
>
> 1) Customer should be same
> 2) Profit Center
Hi Rajeyssh,
Please use this formula for formating
=VALUE($E6)>VALUE($F6)
as i saw u have wrriten $E$6>$F6 which correct but it not working because
all the values in column F is text type so first convert it into Value then
compare it.
regards
Prince
On Tuesday, September 25, 2012 3:19
blue
On Oct 28, 1:02 am, RolfJ wrote:
> What do you mean by 'Any color?'
>
> On Oct 27, 6:01 am, Bajji wrote:
>
>
>
> > Hi Rolf,
>
> > Let me put an example:
>
> > 1. Assume sheet1 has some information from Cells ranging A1 : G20
> > 2. When I run the macro, it should pop user form with 2 input
What do you mean by 'Any color?'
On Oct 27, 6:01 am, Bajji wrote:
> Hi Rolf,
>
> Let me put an example:
>
> 1. Assume sheet1 has some information from Cells ranging A1 : G20
> 2. When I run the macro, it should pop user form with 2 input fields
> asking for cell range (example A1 and C6) to colo
I am sorry, but I am still not quite clear. What do you now mean by
'any color'?
On Oct 27, 6:01 am, Bajji wrote:
> Hi Rolf,
>
> Let me put an example:
>
> 1. Assume sheet1 has some information from Cells ranging A1 : G20
> 2. When I run the macro, it should pop user form with 2 input fields
> a
Hi
If I understood correctly what you are trying to do, I would suggest you to
use "RefEdit" control which you may find in the additional controls dialog
box in form toolbox. It will allow the user to select a range from the
worksheet.
then u can use the following code (supposing the name of the
Hi Rolf,
Let me put an example:
1. Assume sheet1 has some information from Cells ranging A1 : G20
2. When I run the macro, it should pop user form with 2 input fields
asking for cell range (example A1 and C6) to color
3. Based on the above cell ranges A1:C6, the macro should color(Any
color) the
I am sorry, but I don't understand what you mean. Please try again.
On Oct 24, 5:08 am, Bajji wrote:
> Hi Rolf,
> I need similar help, little different way
>
> When I run the Macro, user form should pop up allowing to put the
> array (a1: j10) details to color the rows
>
> Regards,
> Sri
>
> On
Hi Rolf,
I need similar help, little different way
When I run the Macro, user form should pop up allowing to put the
array (a1: j10) details to color the rows
Regards,
Sri
On Oct 24, 4:53 am, RolfJ wrote:
> I can't figure a way to do this by way of conditional formating, but I
> can offer some
HI Rolf,
Thanks for providing the solution.
I need similar help, but little different way.
When I run the macro, user form should
On Oct 24, 4:53 am, RolfJ wrote:
> I can't figure a way to do this by way of conditional formating, but I
> can offer some VBA code that would do the trick. Place
I can't figure a way to do this by way of conditional formating, but I
can offer some VBA code that would do the trick. Place the following
code into the a standard VBA module of your workbook:
Public Sub ColorTable()
Dim rRow As Range
For Each rRow In ActiveSheet.UsedRange.Rows
I
12 matches
Mail list logo
