| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Cell to Red
I have an End Date of my spreadsheet of projects. If the project wasn't
completed on time I would like box to turn red. Is there a way to do that? If so, please help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change Cell to Red
click on the cell, from the menu bar- Format / Conditional formatting
"Sher" wrote: I have an End Date of my spreadsheet of projects. If the project wasn't completed on time I would like box to turn red. Is there a way to do that? If so, please help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change Cell to Red
use conditional formatting:
Formats<Conditional Formatting Make "Cell Value is" "Greater Than" and input your cutoff date. Copy that cell Highlight the entire column Edit<Paste Special Select Formats and click Ok "Sher" wrote: I have an End Date of my spreadsheet of projects. If the project wasn't completed on time I would like box to turn red. Is there a way to do that? If so, please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making copied cells change with change in original cell | Excel Worksheet Functions | |||
| change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
| How do I change a number in one cell to change a series of cells? | Excel Discussion (Misc queries) | |||
| excel deleting rows last cell does not change. How to change? | Excel Discussion (Misc queries) | |||
| Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
Hybrid Mode
