| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Color and Date
I have date column and i need Friday in red color and rest of the week days
in blue color How can I do that? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Color and Date
Format all the range as blue (font or fill???).
Then you can use format|Conditional formatting (xl2003 menus) to color the reds. Select the range Format|Conditional formatting Formula is: =WEEKDAY(A1)=6 Change A1 to the activecell's address. cnalaka wrote: I have date column and i need Friday in red color and rest of the week days in blue color How can I do that? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting a fill color on a certain date | Excel Worksheet Functions | |||
| Date Function and Color Code | Excel Worksheet Functions | |||
| I want any date 90 days or older from current date change color | Excel Worksheet Functions | |||
| Color Code Date Checking | Excel Worksheet Functions | |||
| how do I get a font color to change after a certain date? | Excel Discussion (Misc queries) | |||
Linear Mode
