Change the text colour of a cell when opening up a sheet

G

Guest

Is there anyway I can change the colour of text within a cell depending on some criteria when a spreadsheet opens

e.g

When the Time Left column is under 10, can I change the text of that cell to red

Order no Date ordered Est Del Date Time Lef
A1 01/05/2004 15/05/2004
A2 01/05/2004 01/06/2004 2
A3 01/05/2004 22/05/2004 1

So A1 should already have red text in the Time Left column, but A3 will change to red when the spreadsheet is opened tomorrow.
 
A

Andy B

Hi

Have a look at Format / Conditional Formatting. Select the Time Left column
and go to Conditional Formatting. With Cell Is displayed on the left, select
Is Less Than in the next box and type in 10 in the last box. Then select
what format you require from the other tabs (colour, font, pattern etc)

--
Andy.


cdb said:
Is there anyway I can change the colour of text within a cell depending on
Click to expand...
some criteria when a spreadsheet opens?
e.g.

When the Time Left column is under 10, can I change the text of that cell to red?

Order no Date ordered Est Del Date Time Left
A1 01/05/2004 15/05/2004 3
A2 01/05/2004 01/06/2004 20
A3 01/05/2004 22/05/2004 10

So A1 should already have red text in the Time Left column, but A3 will
Click to expand...
change to red when the spreadsheet is opened tomorrow.
 
M

Max

Try this:

Assume "Time Left" is in col D,
"Est Del Date" is in col C
------------------------
Put in D2: =C2-TODAY()
Copy down to D4

Select D2:D4

Click Format > Conditional Formatting

Make the settings under Condition 1:
Cell Value Is | less than | 10

Click Format button and
format the font to red/bold (in Font tab) > OK

Click OK at the main dialog

--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
----
cdb said:
Is there anyway I can change the colour of text within a cell depending on
Click to expand...
some criteria when a spreadsheet opens?
e.g.

When the Time Left column is under 10, can I change the text of that cell to red?

Order no Date ordered Est Del Date Time Left
A1 01/05/2004 15/05/2004 3
A2 01/05/2004 01/06/2004 20
A3 01/05/2004 22/05/2004 10

So A1 should already have red text in the Time Left column, but A3 will
Click to expand...
change to red when the spreadsheet is opened tomorrow.
 
G

Guest

Many thanks agai

----- Andy B wrote: ----

H

Have a look at Format / Conditional Formatting. Select the Time Left colum
and go to Conditional Formatting. With Cell Is displayed on the left, selec
Is Less Than in the next box and type in 10 in the last box. Then selec
what format you require from the other tabs (colour, font, pattern etc

--
Andy


cdb said:
Is there anyway I can change the colour of text within a cell depending o
Click to expand...
some criteria when a spreadsheet opens
Lef
A1 01/05/2004 15/05/2004
A2 01/05/2004 01/06/2004 2
A3 01/05/2004 22/05/2004 1
Click to expand...
change to red when the spreadsheet is opened tomorrow
 

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

how to set reminder? 3
Change Cell colour on click 5
Changing coloue cell en text colour by clicking cell 3
What's sintaxe or formula, please 7
Conditional formatting.. how do I copy cells? 2
Calculations within summary cells, reflecting the visble cells only after filtering 5
very urgent (advance filter) 5
Can i format (colour) selective text in a cell using excel2000? 3

Top