Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I set conditional formatting in Excel for text sentences?
Hi -- I have a Excel document with several text boxes that I would like to
have highlighted based on certain criteria of a text match. Can conditional formatting do this? For example, "Not enough product is sent early..." And I want the conditional format to be "not enough" to highlight the box yellow. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I set conditional formatting in Excel for text sentences?
If the first part of the text is unique for your format you could set the
conditional format condition to formula is =FIND("Not",G8), where 'Not' is the text and G8 is the cell. This will format the complete cell not just the word as you can not do just 1 word in a cell. -- John MOS Master Instructor Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "David" wrote: Hi -- I have a Excel document with several text boxes that I would like to have highlighted based on certain criteria of a text match. Can conditional formatting do this? For example, "Not enough product is sent early..." And I want the conditional format to be "not enough" to highlight the box yellow. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I set conditional formatting in Excel for text sentenc
Thanks for your help... Will this formula work on an entire worksheet where I
want every instance of those words highlighted? (The whole cell highlighted.) "john the confused" wrote: If the first part of the text is unique for your format you could set the conditional format condition to formula is =FIND("Not",G8), where 'Not' is the text and G8 is the cell. This will format the complete cell not just the word as you can not do just 1 word in a cell. -- John MOS Master Instructor Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "David" wrote: Hi -- I have a Excel document with several text boxes that I would like to have highlighted based on certain criteria of a text match. Can conditional formatting do this? For example, "Not enough product is sent early..." And I want the conditional format to be "not enough" to highlight the box yellow. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I set conditional formatting in Excel for text sentenc
do it in one cell then use the fill handle and drag it to the other cells you
want, then use the fill option to select formatting only -- John MOS Master Instructor Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "David" wrote: Thanks for your help... Will this formula work on an entire worksheet where I want every instance of those words highlighted? (The whole cell highlighted.) "john the confused" wrote: If the first part of the text is unique for your format you could set the conditional format condition to formula is =FIND("Not",G8), where 'Not' is the text and G8 is the cell. This will format the complete cell not just the word as you can not do just 1 word in a cell. -- John MOS Master Instructor Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "David" wrote: Hi -- I have a Excel document with several text boxes that I would like to have highlighted based on certain criteria of a text match. Can conditional formatting do this? For example, "Not enough product is sent early..." And I want the conditional format to be "not enough" to highlight the box yellow. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
APPLY CONDITIONAL FORMATTING TO A ROW IN EXCEL | Excel Discussion (Misc queries) | |||
Excel 2007 Conditional Formatting barely works | Excel Discussion (Misc queries) | |||
Conditional Formatting for Excel XP. | Excel Worksheet Functions | |||
Conditional Formatting in Excel | Excel Worksheet Functions | |||
increase conditional formatting in Excel | Excel Worksheet Functions |