Worksheet change event if in range negative value find then higlight the value

Hi
With worksheet event
Higlight the range d10:d1000 if negative value found in range f10:f1000

For example
I type in a5 and f5 value <0 then highlight the cell a5 and all cells of ranged10:d1000 if value = a5

Hello HaroonSid,

Have you considered using Conditional Formatting instead? It would be much simpler, quick and effective.

Regards.

Hello, guru ji
How r you?

I am using conditional formmating but i want to do this with vba

My workbook has been crashed due to conditional formatring
So i am little afraid using cf

Hi HaroonSid,

My workbook has been crashed due to conditional formatting

There must be a simple way to solve that problem, please could you attach a sample workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi, dear sir
please see this code. this code meets with my need

this code compares two ranges, d3:d300 and f4:f100
if any value in f4:f100 don't match with range d3:d300 then this code highlight the range value of range f4:f100

now my need here is if range Highlight the range d10:d1000 if negative value found in range f10:f1000 in same sheet

and look the sample workbook too please

Please Login or Register  to view this content.

Hi HaroonSid,

Please try the following Code,

In a Standard Module;

Please Login or Register  to view this content.

In Sheet1. Change Event;

Please Login or Register  to view this content.

Sample Workbook to Follow.

Kind Regards.

Hello HaroonSid,

Perhaps the amended attached sample Workbook will suit you better, since I got no reply from you after my last Post.

Kind Regards.

Yes
this is perfect

Mr. Winon Sir

i was busy so no reply
sorry for that

thank you

i need little change in this code

highlight all cells of less then 0 (-1, -2, -15, -18, -500 any minus value) not only -1 of range Column D

Please Login or Register  to view this content.

O.K. HaroonSid,

Just change your Module to;

Please Login or Register  to view this content.

Regards.

Ok
Thank you sir winon

Will try tomorrow InshaAllah

Hi HaroonSid,

I checked it all again, and I think the following Module Code will suit you better;

Please Login or Register  to view this content.

You may now select which ever solution suits you best.

വരാനിരിക്കുന്നു.

Ekdum Perfect

thank you once again

Hello HaroonSid,

You are welcome.

Thank you for the feedback and the Rep.

With your issue confirmed as Solved we can now finalize the Module Code.

Please replace your Code with the content below;

Please Login or Register  to view this content.

Kind Regards.