Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I make it change colour
I am tracking dates in excel... basically as follows... Start date to
completed date... I am looking into how to make a cell change colour after a certain amount have days have passed? example: (a1= June 1st 2005 a2= completed date )after 5 days from start date.. change the completed date cell red. Thanks Ron |
#2
|
|||
|
|||
Go to FormatConditional Format.
"raven_guy" wrote: I am tracking dates in excel... basically as follows... Start date to completed date... I am looking into how to make a cell change colour after a certain amount have days have passed? example: (a1= June 1st 2005 a2= completed date )after 5 days from start date.. change the completed date cell red. Thanks Ron |
#3
|
|||
|
|||
Sorry.... What do I do from there.
Ron "Pat Flynn" wrote: Go to FormatConditional Format. "raven_guy" wrote: I am tracking dates in excel... basically as follows... Start date to completed date... I am looking into how to make a cell change colour after a certain amount have days have passed? example: (a1= June 1st 2005 a2= completed date )after 5 days from start date.. change the completed date cell red. Thanks Ron |
#4
|
|||
|
|||
Select A2, then:
<Format <Conditional Format, Click "Formula Is", Then enter this: =A2A1+4 Click on "Format", and choose what you wish, Then <OK <OK -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "raven_guy" wrote in message ... I am tracking dates in excel... basically as follows... Start date to completed date... I am looking into how to make a cell change colour after a certain amount have days have passed? example: (a1= June 1st 2005 a2= completed date )after 5 days from start date.. change the completed date cell red. Thanks Ron |
#5
|
|||
|
|||
When oyou select "Conditional Fromatting" a box will appear. You can set
either "Cell value" or formula is. In your case select "cell value" tab to the drob down list and select equal to or greater than for your condition. Then select format. This gives you the option of changing the border color, font color, or background color if a condition is met. You can use up to three conditions in the method. Just lay with it a bit-its quite simple. Good Luck Pat "raven_guy" wrote: Sorry.... What do I do from there. Ron "Pat Flynn" wrote: Go to FormatConditional Format. "raven_guy" wrote: I am tracking dates in excel... basically as follows... Start date to completed date... I am looking into how to make a cell change colour after a certain amount have days have passed? example: (a1= June 1st 2005 a2= completed date )after 5 days from start date.. change the completed date cell red. Thanks Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
I Need to change reference sheet for all cells on a form | Excel Discussion (Misc queries) | |||
How do I get traffic lights in excel that change colour | Excel Worksheet Functions | |||
Macro button colour change??? | Excel Worksheet Functions | |||
Text in Blue colour, but print in black colour | Excel Worksheet Functions |