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

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

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