Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can I color true or false results differently in excel
I want to identify the day of the week in my spreadsheet and have used the
formula =IF(WEEKDAY(L2)=1,"SU",IF(WEEKDAY(L2)=2,"M",IF(WEE KDAY(L2)=3,"T",IF(WEEKDAY(L2)=4,"W",IF(WEEKDAY(L2) =5,"TH",IF(WEEKDAY(L2)=6,"F",IF(WEEKDAY(L2)=7,"SA" ,""))))))) where the L2 cell would have a date (ie 04/10/2008) but would like the weekdays (M-F) to be black and have SA and SU come up red. any ideas / suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
Indexing/Matching True/False results | Excel Worksheet Functions | |||
Convert TRUE/FALSE results to a number | Excel Worksheet Functions | |||
How can I make a True or False statement a certain color when usi. | Excel Worksheet Functions | |||
Adding True False Results | Excel Worksheet Functions |