CONDITIONAL FORMATTING

[verluc]

I have copied a macro from Ivan MOALA:
http://www.mrexcel.com/hof001.php

It doesn't work for me.However I can see the result in the toolbar:Formatting > Conditional formatting > Formula is TRUE with the right colour.
but when I see the sheet, I get no colour .
This seems very difficult to become a solution on this,because I have many times ask this on this board.
Can somebody give me a solution?
Many,many thanks

 

[Ekim]

Works perfectly for me.

Using Excel97-SR2 with Win95 (if it works on this ancient configuration, it should work on any configuration).

As Ian Mac stated, the code has to be in a worksheet module. However, I noted that the code did not "take" immediately until the following default code was deleted from the worksheet module:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

End Sub

Regards,

Mike

 

[verluc]

On 2002-09-04 21:39, Ekim wrote:
Works perfectly for me.

Using Excel97-SR2 with Win95 (if it works on this ancient configuration, it should work on any configuration).

As Ian Mac stated, the code has to be in a worksheet module. However, I noted that the code did not "take" immediately until the following default code was deleted from the worksheet module:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

End Sub

Regards,

Mike

Hi,
Yes the code works also for me,but I get no colour.When I make a test in the toolbar
(conditional formatting) I can see that the formule is "TRUE" with the right colour.When I press O.K. then also I get no colour on the sheet.
That's my crucial question.Why no colour?
Thanks for any help.

 

[verluc]

On 2002-09-04 15:30, verluc wrote:

On 2002-09-04 04:40, verluc wrote:

On 2002-09-03 04:31, verluc wrote:

On 2002-09-03 03:36, Ian Mac wrote:

On 2002-09-03 03:16, verluc wrote:

On 2002-09-03 03:05, Ian Mac wrote:
Are you placing it in the Worksheet module, NOT a Standard or ThisWorkbook?
I assume you are as you say the Conditional Formatting is correct.

It does work fine for me though.
You can send the book to me if you want.

Hi Ian,

I have send you my workbook via e-mail.
Thanks for this possibility.
If you prefer,you can answer via this board.
So long.

Hi, thank but it was really helpful to send me a workbook with protection .
Project unveiwable message.

Hi Ian,

What do you mean with : Project inveiwable message?Is my workbook not protected?
Thanks

Hi Ian,
Is this a difficult one?

This is my last call to all excel experts who knows something from macro's.
Can someone give me a solution why I get no colours on the sheet,
Thanks in advance.

Hi Excellers,

With the macro from Ivan F.MOALA,everybody says : it works fine for me.
Can you explain exactly what you are doing afther download this macro,because it works not for me.%aybe I do something wrong.
Many thanks

 

[Ian Mac]

On 2002-09-05 05:59, verluc wrote:

On 2002-09-04 15:30, verluc wrote:

On 2002-09-04 04:40, verluc wrote:

On 2002-09-03 04:31, verluc wrote:

On 2002-09-03 03:36, Ian Mac wrote:

On 2002-09-03 03:16, verluc wrote:

On 2002-09-03 03:05, Ian Mac wrote:
Are you placing it in the Worksheet module, NOT a Standard or ThisWorkbook?
I assume you are as you say the Conditional Formatting is correct.

It does work fine for me though.
You can send the book to me if you want.

Hi Ian,

I have send you my workbook via e-mail.
Thanks for this possibility.
If you prefer,you can answer via this board.
So long.

Hi, thank but it was really helpful to send me a workbook with protection .
Project unveiwable message.

Hi Ian,

What do you mean with : Project inveiwable message?Is my workbook not protected?
Thanks

Hi Ian,
Is this a difficult one?

This is my last call to all excel experts who knows something from macro's.
Can someone give me a solution why I get no colours on the sheet,
Thanks in advance.

Hi Excellers,

With the macro from Ivan F.MOALA,everybody says : it works fine for me.
Can you explain exactly what you are doing afther download this macro,because it works not for me.%aybe I do something wrong.
Many thanks

Hi,

You sent me a workbook BUT I

A) couldn't veiw the project in VBA
B) it had other Macro's in running around I couldn't understand (i.e. they weren't english)

I'll have another look and try to get back to you.

Also, you try using:

Public dRow, dCol As Double

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error Resume Next
Rows(dRow).Interior.ColorIndex = xlNone
Rows(Target.Row).Interior.ColorIndex = 36
Columns(dCol).Interior.ColorIndex = xlNone
Columns(Target.Column).Interior.ColorIndex = 36
dRow = Target.Row
dCol = Target.Column
End Sub

in the worksheet module, it doesn't rely on Conditional formating and is not as fancy as Ivans.

 

[verluc]

On 2002-09-05 06:25, Ian Mac wrote:

On 2002-09-05 05:59, verluc wrote:

On 2002-09-04 15:30, verluc wrote:

On 2002-09-04 04:40, verluc wrote:

On 2002-09-03 04:31, verluc wrote:

On 2002-09-03 03:36, Ian Mac wrote:

On 2002-09-03 03:16, verluc wrote:

On 2002-09-03 03:05, Ian Mac wrote:
Are you placing it in the Worksheet module, NOT a Standard or ThisWorkbook?
I assume you are as you say the Conditional Formatting is correct.

It does work fine for me though.
You can send the book to me if you want.

Hi Ian,

I have send you my workbook via e-mail.
Thanks for this possibility.
If you prefer,you can answer via this board.
So long.

Hi, thank but it was really helpful to send me a workbook with protection .
Project unveiwable message.

Hi Ian,

What do you mean with : Project inveiwable message?Is my workbook not protected?
Thanks

Hi Ian,
Is this a difficult one?

This is my last call to all excel experts who knows something from macro's.
Can someone give me a solution why I get no colours on the sheet,
Thanks in advance.

Hi Excellers,

With the macro from Ivan F.MOALA,everybody says : it works fine for me.
Can you explain exactly what you are doing afther download this macro,because it works not for me.%aybe I do something wrong.
Many thanks

Hi,

You sent me a workbook BUT I

A) couldn't veiw the project in VBA
B) it had other Macro's in running around I couldn't understand (i.e. they weren't english)

I'll have another look and try to get back to you.

Also, you try using:

Public dRow, dCol As Double

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error Resume Next
Rows(dRow).Interior.ColorIndex = xlNone
Rows(Target.Row).Interior.ColorIndex = 36
Columns(dCol).Interior.ColorIndex = xlNone
Columns(Target.Column).Interior.ColorIndex = 36
dRow = Target.Row
dCol = Target.Column
End Sub

in the worksheet module, it doesn't rely on Conditional formating and is not as fancy as Ivans.

Hi,

Your macro works for me,but he gives me not the result like Ivan's macro and that is just the case.
So long