Conditional Formatting using seconds ....!!

**Fotis1991** · 11-10-2011, 11:08 AM

Hi.

My point I need your help, is this:
When I select "OPEN" in a cell, say Β1, then with conditional formatting, I'd like after "X" seconds, the adjacent cells to change color.
Thank you in advance.

**Hestha** · 11-10-2011, 11:48 AM

I think this tutorial is what you need: http://www.techonthenet.com/excel/qu...rmat1_2010.php

**Fotis1991** · 11-10-2011, 12:10 PM

ΗΙ.

Thank you very much for your answer, but i know the general rules of conditional formatting.
In what I'm asking you now, I can not find the formula needed to get me the desired result. So if I have the word "OPEN" in a cell, then after 5 seconds (for example) a particular cell to change color. This is my question.

**Hestha** · 11-10-2011, 01:51 PM

On the website, pacoonejr asks a similar question on how to control the timing of the worksheet. It looks like the job may require some knowledge on VBA. Mark O' Brien responds with the following code:

Please Login or Register  to view this content.

Since you have mentioned that you want 5 seconds, not 15, you may copy this code and change 15 to 5. However, you may also want to change everything that comes after the line that says "Start = Timer". So instead of completely copying the code above, you may want to know how to write in VBA language how to command a cell to change color after 5 seconds upon the command of "OPEN".

Unfortunately, I am still a novice at VBA, so I cannot help you on the actual code.

**Fotis1991** · 11-11-2011, 08:35 AM

Thank you for your interesting.

As i don't know VBA, i can't do something with that.!!

This is the reason that i asked a solution with conditional formating!

Does anyone else friend can help?
I would appreciate it very much.

**daddylonglegs** · 11-11-2011, 09:49 AM

I don't believe you can do this without VBA - you could use conditional formatting to format a cell once a particular time is passed but you need VBA probably to

1) create that fixed time in the first place (when "Open" is selected) and
2) to update the sheet so that the system time is applied , e.g. every second

**Fotis1991** · 11-11-2011, 10:22 AM

Hi

Once the expert says it can not be done with conditional formatting, then I accept ιτ.
But allow me one more question.
In VBA, is it difficult to do? Is great code? Easy for a beginner like me?

Thank you very much.