in spreadsheets copying cell contents plus font colour

N

NDBC

I am working with formulas in spreadsheets now not in vba code. I have one
sheet that has the time (as in time of day) each rider finishes each lap. The
code has a check in it so that if the lap time had a variance from the
average for that rider of more than 20% then the time is written in a red
font.

The second sheet calculates the actual time each lap took (ie lap 2 end time
- lap1 end time). Whilst the maths part works well and is easy what i would
like is for if the lap 2 time is in red font then the calculated lap time is
in red font. Sounds like conditional formatting. I might investigate this
whilst i await a response.

Thanks
 
G

Gary Keramidas

you can't use conditional formatting to reference another sheet. so if you
want a programming solution, post back.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with program planning 1
Counting cells with a certain font colour 3
clearing array variables and using an array to determine min value 7
Conditionl format a cell to change text colour 5
Forms and macro design check 1
counting values as they turn up in a column 4
Insert text depending on font colour 2
Change colour of font in a textbox? 2

Top