Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formating not functioning in cell with formula?
hi My question is how can i put a font color on cell if day = sat. Scenario is Cell A1 = 10/11 Cell B1 = Sat ( i used custom formating ddd - to change the date to days in reference to A1 = cell B1(=A1) but when i used conditional formating: cell value is equal to SAT, it doesnt change the font color? i |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formating not functioning in cell with formula?
Because although SAT is displayed, the cell value is still the date.
Try the following (assuming in cell B2): Conditional Formatting Change dropdown to Formula is: =WEEKDAY(B2)=7 add your formatting preference. Hope that helps. -- John C "Excel" wrote: hi My question is how can i put a font color on cell if day = sat. Scenario is Cell A1 = 10/11 Cell B1 = Sat ( i used custom formating ddd - to change the date to days in reference to A1 = cell B1(=A1) but when i used conditional formating: cell value is equal to SAT, it doesnt change the font color? i |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formating not functioning in cell with formula?
thanks John, one more question if ill be including the Sun, what formula will
i be using? "John C" wrote: Because although SAT is displayed, the cell value is still the date. Try the following (assuming in cell B2): Conditional Formatting Change dropdown to Formula is: =WEEKDAY(B2)=7 add your formatting preference. Hope that helps. -- John C "Excel" wrote: hi My question is how can i put a font color on cell if day = sat. Scenario is Cell A1 = 10/11 Cell B1 = Sat ( i used custom formating ddd - to change the date to days in reference to A1 = cell B1(=A1) but when i used conditional formating: cell value is equal to SAT, it doesnt change the font color? i |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formating not functioning in cell with formula?
hi John I already figure it out my second question adding Sunday thanks on
the list to be formatted thanks! "John C" wrote: Because although SAT is displayed, the cell value is still the date. Try the following (assuming in cell B2): Conditional Formatting Change dropdown to Formula is: =WEEKDAY(B2)=7 add your formatting preference. Hope that helps. -- John C "Excel" wrote: hi My question is how can i put a font color on cell if day = sat. Scenario is Cell A1 = 10/11 Cell B1 = Sat ( i used custom formating ddd - to change the date to days in reference to A1 = cell B1(=A1) but when i used conditional formating: cell value is equal to SAT, it doesnt change the font color? i |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formating not functioning in cell with formula?
Thanks for the feedback, and don't forget to check the little YES box below :)
-- John C "Excel" wrote: hi John I already figure it out my second question adding Sunday thanks on the list to be formatted thanks! "John C" wrote: Because although SAT is displayed, the cell value is still the date. Try the following (assuming in cell B2): Conditional Formatting Change dropdown to Formula is: =WEEKDAY(B2)=7 add your formatting preference. Hope that helps. -- John C "Excel" wrote: hi My question is how can i put a font color on cell if day = sat. Scenario is Cell A1 = 10/11 Cell B1 = Sat ( i used custom formating ddd - to change the date to days in reference to A1 = cell B1(=A1) but when i used conditional formating: cell value is equal to SAT, it doesnt change the font color? i |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formating formula | Excel Worksheet Functions | |||
Conditional Formating Formula? | Excel Discussion (Misc queries) | |||
Conditional Formating and Formula | Excel Discussion (Misc queries) | |||
if, then formula with conditional formating | Excel Worksheet Functions | |||
If Formula or conditional formating | Excel Discussion (Misc queries) |