| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formatting a cell for color that has a formula also
I am using this formula =If ($A$1="","",A1+1) so that when i put a date in it
adds the next date to it. I want to be able to get Saturday and Sunday to change to a yellow color to note that its a weekend date can this be done? I can do it manually but would like to be able to do it automatically if possible. Thanks Karl |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using contents of a cell in a formula | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Percent and Rank formula in one cell | Excel Discussion (Misc queries) | |||
| Formatting dates in the future | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
