how to program the auto highliting ..

**funtastic** · 10-01-2011, 08:50 AM

hi all

sorry if my english is not good..

i have a table time & values

i want when i enter time in the cell (A1) the same time and value in the table highlited and colored

i attache excel to be clear

thank you

**funtastic** · 10-01-2011, 09:38 AM

changed bro ..

**watersev** · 10-01-2011, 03:02 PM

hi, funtastic, please check attachment, you just needed to extend conditional format for the other three columns

**funtastic** · 10-01-2011, 04:54 PM

this is excatly excatly what i want

thank you alot alot

**watersev** · 10-01-2011, 05:05 PM

if the issue is resolved please mark the thread as Solved, see forum rules for details: http://www.excelforum.com/forum-rule...rum-rules.html, rule #9