Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I auto change text colour in excel to reflect the value ent
I'm using office 2000, I'm trying to get the text for a row to change colour
according to the value that is calculated as a percentage in the last box... EG: For values between 0 - 90% Red Text, 91 - 95% Amber, 96 - 100% Green... Any clues, Thanx... |
#2
|
|||
|
|||
COnditional Formatting (from the Format Menu) is your simplest solution. Set your conditions based on an absolute reference and a Formula Is if you want to base the formatting from one cell: Condition1 : =if(AND($A$10,$A$1<.9),True,False) where A1 is the cell that contains the percentage that sets the format for the row (your "Last Box" as posted). use the Format... Font tab to set the colour as required. Set the other conditions as required You are limited to 3 conditions (Excel Limit I'm afraid); You could write some VB that gets you around this based on events in a range on the sheet - too much to detail here if you don't need it ... -- optionbase1 ------------------------------------------------------------------------ optionbase1's Profile: http://www.excelforum.com/member.php...o&userid=25212 View this thread: http://www.excelforum.com/showthread...hreadid=388910 |
#3
|
|||
|
|||
Hi,
While conditional formatting may be the best way to accomplisht this, there is another way to accoimplisht this by using format cells. Select the cell to be coloured and press Ctrl+1 (Format celsl dialog box) Now under custome category type the following in the Type box [Red][<0.9]0%;[Green][<0.95]0%;0% While you do not get the colours you want, it still serves the purpose. Also remember to format the cell in % format Regards, "sslurp00" wrote: I'm using office 2000, I'm trying to get the text for a row to change colour according to the value that is calculated as a percentage in the last box... EG: For values between 0 - 90% Red Text, 91 - 95% Amber, 96 - 100% Green... Any clues, Thanx... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
axis title text box is wrong size in chart for excel 2003 | Charts and Charting in Excel | |||
Exporting excel to text file | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) |