Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting based on cell text
I am currently filling in the entire row Yellow if the cell in column Q
doesn't have anything in it. I want to fill with a different color if the first characters in the cell are "Shipped". How do I do this? I am using the following formula to fill it yellow... =NOT(ISBLANK($Q4)) Thanks! --- Posted via news://freenews.netfront.net/ - Complaints to --- |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting based on cell text
Hi,
Am Tue, 22 May 2012 14:27:46 -0400 schrieb Saucer Man: I am currently filling in the entire row Yellow if the cell in column Q doesn't have anything in it. I want to fill with a different color if the first characters in the cell are "Shipped". How do I do this? I am using the following formula to fill it yellow... try: =SEARCH("Shipped",$Q4)=1 or =LEFT($Q4,7)="Shipped" Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting based on cell text
In message of Tue, 22 May 2012
14:27:46 in microsoft.public.excel.worksheet.functions, Saucer Man writes I am currently filling in the entire row Yellow if the cell in column Q doesn't have anything in it. I want to fill with a different color if the first characters in the cell are "Shipped". How do I do this? I am using the following formula to fill it yellow... =NOT(ISBLANK($Q4)) I do that with two conditional formats. On B3, I have Condition 1 Cell Value Is greater than 10 and Condition 2 Formula Is =AND(B3<4,B3<" The Format...s for the two conditions select different colors in the Patterns tab. -- Walter Briscoe |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting based on cell text
Thanks all. This worked.
"Claus Busch" wrote in message ... Hi, Am Tue, 22 May 2012 14:27:46 -0400 schrieb Saucer Man: I am currently filling in the entire row Yellow if the cell in column Q doesn't have anything in it. I want to fill with a different color if the first characters in the cell are "Shipped". How do I do this? I am using the following formula to fill it yellow... try: =SEARCH("Shipped",$Q4)=1 or =LEFT($Q4,7)="Shipped" Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 --- Posted via news://freenews.netfront.net/ - Complaints to --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting based on text in another cell | Excel Discussion (Misc queries) | |||
Conditional formatting based off cell with text? (i.e. "less than | Excel Discussion (Misc queries) | |||
Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
Conditional formatting of adjacent cells based on text in cell | Excel Programming | |||
Conditional formatting of an entire row based on a cell text entry | Excel Discussion (Misc queries) |