Help in Excel

James240

Guys and Girls, Is there a way to highlight text after a certain time period has elapsed? What i want to do is have the months of the year showing on a spreadsheet in say yellow but when it is actually that month the text would turn to say red..... Any advice on how to do this would be most appreciated. Many thanks James P.S im using Excel 2003

isofa

You can do this using Conditional Formatting (from the Format menu). Compare the date in the cell, with today, usually referred to as DATE() and away you go.

James240

thanks isofa ill give that a go :beer:

little-miss-little

I have another question for excel experts:
We're trying to find a formula that can take across some information from two ranges of information that could also work out a range within that. Complicated i know.
For example: Two columns of information and to carry across the result if it's between 10 and 20.
I've managed to work it out using SUMIF if it's <10 or >20 but i can't work out how it can carry across the info that could be inbetween.

Hope that makes sense.

Thanks.

isofa

little-miss-little wrote: »

I have another question for excel experts:
We're trying to find a formula that can take across some information from two ranges of information that could also work out a range within that. Complicated i know. For example: Two columns of information and to carry across the result if it's between 10 and 20. I've managed to work it out using SUMIF if it's <10 or >20 but i can't work out how it can carry across the info that could be inbetween.
Hope that makes sense. Thanks.

Ignoring the multi-ranges you mention, just to evaluate a figure in a single cell between two values, you need to nest an IF to achieve the result.

e.g: for a figure in A1, if it's between 10 and 20 this will return True or False in the cell you place the forumla:

=IF(A14>=10,IF(A14<=20,"True","False"),"False")

If you want just to copy the figure across if it is true, and set it to blank if it isn't then:

=IF(A14>=10,IF(A14<=20,A1,""),"")

Hope that helps!