Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting to Show Red Highlight in Text Field
Hello. I have text values in column D that contain the word Saturday. I
need a conditional format that turns the cells red to use in column D to find those cells that contain Saturday. I think a formula can be used in conditional formatting but I am unsure what it can be. How can I do this? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting to Show Red Highlight in Text Field
What's wrong with a conditional format of:
Value is: Saturday Format: red color ? Regards, Fred. "Daren" wrote in message ... Hello. I have text values in column D that contain the word Saturday. I need a conditional format that turns the cells red to use in column D to find those cells that contain Saturday. I think a formula can be used in conditional formatting but I am unsure what it can be. How can I do this? Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting to Show Red Highlight in Text Field
To clarify, you want all cells in column D that say "Saturday" to have red
background? Format-Condition Format, Cell value is equal to "Saturday". Choose red pattern. Or, if you wanted a corresponding column to change color Formula is: =D1="Saturday" and then pick pattern, and copy cell down as desired. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Daren" wrote: Hello. I have text values in column D that contain the word Saturday. I need a conditional format that turns the cells red to use in column D to find those cells that contain Saturday. I think a formula can be used in conditional formatting but I am unsure what it can be. How can I do this? Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting to Show Red Highlight in Text Field
I tried that but it did not take, and I think that is due to the fact that
there are other words in the cell, such as The First (Saturday). Is there a way to get around this? Thanks. "Fred Smith" wrote: What's wrong with a conditional format of: Value is: Saturday Format: red color ? Regards, Fred. "Daren" wrote in message ... Hello. I have text values in column D that contain the word Saturday. I need a conditional format that turns the cells red to use in column D to find those cells that contain Saturday. I think a formula can be used in conditional formatting but I am unsure what it can be. How can I do this? Thanks. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting to Show Red Highlight in Text Field
Not totally...the cells in column D can also have other words in it, such as
The First (Saturday). I want the conditional format to show red whenever the word Saturday appears in the cell regardless of how many other different words there are. Do you know how to do this? Thanks. "Luke M" wrote: To clarify, you want all cells in column D that say "Saturday" to have red background? Format-Condition Format, Cell value is equal to "Saturday". Choose red pattern. Or, if you wanted a corresponding column to change color Formula is: =D1="Saturday" and then pick pattern, and copy cell down as desired. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Daren" wrote: Hello. I have text values in column D that contain the word Saturday. I need a conditional format that turns the cells red to use in column D to find those cells that contain Saturday. I think a formula can be used in conditional formatting but I am unsure what it can be. How can I do this? Thanks. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting to Show Red Highlight in Text Field
Ah.
formula for CF is =ISNUMBER(SEARCH("Saturday",D1)) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Daren" wrote: Not totally...the cells in column D can also have other words in it, such as The First (Saturday). I want the conditional format to show red whenever the word Saturday appears in the cell regardless of how many other different words there are. Do you know how to do this? Thanks. "Luke M" wrote: To clarify, you want all cells in column D that say "Saturday" to have red background? Format-Condition Format, Cell value is equal to "Saturday". Choose red pattern. Or, if you wanted a corresponding column to change color Formula is: =D1="Saturday" and then pick pattern, and copy cell down as desired. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Daren" wrote: Hello. I have text values in column D that contain the word Saturday. I need a conditional format that turns the cells red to use in column D to find those cells that contain Saturday. I think a formula can be used in conditional formatting but I am unsure what it can be. How can I do this? Thanks. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting to Show Red Highlight in Text Field
Hi,
Try this as your condtional formatting formula =ISNUMBER(FIND("Saturday",A1)) -- If this helps, please click the Yes button Cheers, Shane Devenshire "Daren" wrote: I tried that but it did not take, and I think that is due to the fact that there are other words in the cell, such as The First (Saturday). Is there a way to get around this? Thanks. "Fred Smith" wrote: What's wrong with a conditional format of: Value is: Saturday Format: red color ? Regards, Fred. "Daren" wrote in message ... Hello. I have text values in column D that contain the word Saturday. I need a conditional format that turns the cells red to use in column D to find those cells that contain Saturday. I think a formula can be used in conditional formatting but I am unsure what it can be. How can I do this? Thanks. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting to Show Red Highlight in Text Field
Hi,
I should also mention that if you are using 2007 there is a simplier way: Highlight the data and choose Home, Conditional Formatting, Highlight Cell Rules, Text that Contains and enter Saturday. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Daren" wrote: I tried that but it did not take, and I think that is due to the fact that there are other words in the cell, such as The First (Saturday). Is there a way to get around this? Thanks. "Fred Smith" wrote: What's wrong with a conditional format of: Value is: Saturday Format: red color ? Regards, Fred. "Daren" wrote in message ... Hello. I have text values in column D that contain the word Saturday. I need a conditional format that turns the cells red to use in column D to find those cells that contain Saturday. I think a formula can be used in conditional formatting but I am unsure what it can be. How can I do this? Thanks. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting to Show Red Highlight in Text Field
Hi,
One more comment - the difference between FIND and SEARCH with regards to your situation - FIND is case sensitive while SEARCH is not. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Daren" wrote: I tried that but it did not take, and I think that is due to the fact that there are other words in the cell, such as The First (Saturday). Is there a way to get around this? Thanks. "Fred Smith" wrote: What's wrong with a conditional format of: Value is: Saturday Format: red color ? Regards, Fred. "Daren" wrote in message ... Hello. I have text values in column D that contain the word Saturday. I need a conditional format that turns the cells red to use in column D to find those cells that contain Saturday. I think a formula can be used in conditional formatting but I am unsure what it can be. How can I do this? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting to highlight the lowest valid value | Excel Worksheet Functions | |||
Highlight the entire row or particular cell using conditional formatting | New Users to Excel | |||
How do I highlight a cell using conditional formatting and dates | Excel Worksheet Functions | |||
Conditional formatting on named text field | Excel Discussion (Misc queries) | |||
Need conditional formatting formula to highlight top ten values i. | Excel Worksheet Functions |