Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Select conditional formatting.
Select formula is Write this formula : =A1:A25="Saturday" ( of course select your own range of cells ) Format as RED text. Click on ADD for another CF and do the same for "Sunday" and click ok. Everytime Saturday or Sunday appear in that range of cells = RED color. Enjoy it. "CoopsCoops" wrote: Now that I have my "ddd" showing Sat, Sun, etc., I need to place conditional formatting that will turn all cells equal to Sat, Sun to Red text. What formula do I use in the conditional formatting to produce this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting within a Formula | Excel Worksheet Functions | |||
Conditional formatting and formula | Excel Worksheet Functions | |||
Conditional Formatting: Formula is | Excel Worksheet Functions | |||
Conditional Formatting Formula | Excel Worksheet Functions | |||
conditional formatting formula | Excel Discussion (Misc queries) |