hi all i need a macro which will compare specified time in one cell with anathor cells if time matches output will be 3rd celll adjucent gets green in color else red if not matched
suppose cell a1 has time 15:30 and cell b1 has 15:33 , it not matches output will be in cell c1 color red
please help me !!!!!!!!!!!!!!!
Why do you need a macro to do this? Conditional formatting will do it for you.
Hope this helps.
Pete
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks