Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
I would like cell B1 to strikethrough and the text turn red if cell C1 equals FLOW THRU. What is the formula i need to use in B1? =c1="FLOW THRU" If that is right when I change the drop down in C1 to FLOW THRU.... nothing happens. Any thoughts? -- Cook ------------------------------------------------------------------------ Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=65182 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
That's the correct formula.
Try following these steps: Select cell B1 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =C1="flow thru" Click the Format button Select the Font tab Set the Color to be RED Select Strikethrough OK out -- Biff Microsoft Excel MVP "Cook" wrote in message ... I would like cell B1 to strikethrough and the text turn red if cell C1 equals FLOW THRU. What is the formula i need to use in B1? =c1="FLOW THRU" If that is right when I change the drop down in C1 to FLOW THRU.... nothing happens. Any thoughts? -- Cook ------------------------------------------------------------------------ Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=65182 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |