Conditional formatting for a row, dependent on one cell.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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


.

Relevant Pages

  • Re: Linked tables to SQL and how to handle triggers on SQL ???
    ... Modify the trigger code to only insert to the archive table if data has ... We have Insert/Update and Delete triggers on the criticle tables that ... archives the changed records to a table _Archive_tableName ...
    (microsoft.public.access.adp.sqlserver)
  • Re: The *86 CPU.
    ... you've already read the preceding paragraph twice, ... Tom Gootee ... Good luck - as Tom notes, a lot of these questions have been beaten to death. ... Search the archives, or as someone else I know suggests: ...
    (sci.electronics.design)
  • Re: httpd-modsec2_debug.log: Operation not permitted
    ... all as a root but no luck ... I use a default setup for logrotate, it then archives each file in ... of it's space before logrotate can clean things up. ...
    (freebsd-questions)
  • Re: Question on how to do a global search and replace
    ... I've looked in the archives for this problem and have tried ... > quite a few different suggestions but so far, no luck. ... The files exist in many directories and subdirectories ... You can do it without the grep, but it's far more efficient with it if not ...
    (comp.unix.solaris)