Macro to color the cell

[supriya pawar.N]

Hi,

i want a macro code which can find the values i type in the pop up and then in the same row if the value is <100 the cell values should be changed to 100 and turned green with comment "Short Term Exception". The same way if the value is "NOK" it shlould change as "OK" with comment "Short Term Exception".

urgent PLS!!!!

[jraj1106]

Hi

Upload the file...

[supriya pawar.N]

Hi,
Pls Find the attached..
Sheet one has the values it need to be filter in sheet 2.. and make the respective described in the previous message

Thanks in advance!


Hello,
i was unable to attache the file,kindly find the link below

C:\Users\pawarns\Desktop\Supriya.xls

Urgent!

[royUK]

No attachment

[supriya pawar.N]

Hi jraj1106 and roy UK,
I am unable to upload the file.. It would be helpfull if you provide your E-mail ID . so I can send it acros to you.

[royUK]

Zip the file before attaching. No emailing of questions & answers are allowed.

[arlu1201]

Supriya,

To Attach a File:

1. Click on Go advanced.
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

If your file is crossing the file upload limits, then zip it and then upload.

[supriya pawar.N]

Hi RoyUK,

Please find the attachement...

>>>Arlu

Thanks a lot

[supriya pawar.N]

hello Roy,

Any update ?

Thanks ,
Supriya

[supriya pawar.N]

Hi ,

Kindly update the status.

Many thanks,
Supriya