Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting for a row, dependent on one cell.
I searched and searched the archives, but I'm not having luck with this one.
I found many examples, but one of the main difficulties is that don't know where the vb code should go which is why I'm having trouble, I guess. My case is that I've done up a To-Do spreadsheet which is working extremely well. There's only one thing missing - when the task is done, I can choose the square root symbol from the pulldown in column A, with the title of "Completed". That should trigger that the row then have the font attribute of "strikethrough" applied to the row, which is from B2 to E2 on row 2, for example. TIA! :oD |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting for a row, dependent on one cell.
Select the range in question, Goto Format... Conditional Formatting...
Change "Cell Value Is" to Formula Is" and enter this: =$B2="v" then click format and check "Strikethrough" Charles Chickering StargateFanFromWork wrote: I searched and searched the archives, but I'm not having luck with this one. I found many examples, but one of the main difficulties is that don't know where the vb code should go which is why I'm having trouble, I guess. My case is that I've done up a To-Do spreadsheet which is working extremely well. There's only one thing missing - when the task is done, I can choose the square root symbol from the pulldown in column A, with the title of "Completed". That should trigger that the row then have the font attribute of "strikethrough" applied to the row, which is from B2 to E2 on row 2, for example. TIA! :oD |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting for a row, dependent on one cell.
"Die_Another_Day" wrote in message ps.com... Select the range in question, Goto Format... Conditional Formatting... Change "Cell Value Is" to Formula Is" and enter this: =$B2="v" then click format and check "Strikethrough" Damn, sorry. I posted another message with a slightly different header as I realized I hadn't stated the situation completely. _All_ the possible 3 conditional formatting slots are already taken for all the cells in the rest of the workbook otherwise I would have used this solution. So what can be done? I know that in the archives there are quite a few solutions for augmenting conditional formatting via vb code but I have 2 problems: - where does one put the code? - the other solutions were for very complex situations compared to this. I just need to put a strikethrough in the row, from column B to E. Thanks so much for your response and sorry I missed providing important information! Cheers. :oD Charles Chickering StargateFanFromWork wrote: I searched and searched the archives, but I'm not having luck with this one. I found many examples, but one of the main difficulties is that don't know where the vb code should go which is why I'm having trouble, I guess. My case is that I've done up a To-Do spreadsheet which is working extremely well. There's only one thing missing - when the task is done, I can choose the square root symbol from the pulldown in column A, with the title of "Completed". That should trigger that the row then have the font attribute of "strikethrough" applied to the row, which is from B2 to E2 on row 2, for example. TIA! :oD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting dependent on whether cell is populated. | Excel Discussion (Misc queries) | |||
conditional formatting dependent of preceding cell | Excel Discussion (Misc queries) | |||
Conditional Formatting dependent on another cell | Excel Discussion (Misc queries) | |||
Data Validation - Dependent Lists & Conditional Formatting | Excel Worksheet Functions | |||
Another cell formatting dependent on cell contents question / message box popup? | Excel Programming |