Apply conditional formatting to a row

Apply conditional formatting to a row

I would like to apply conditional formatting to a row.  This can be really helpful for project based sheets where each row might be associated with a task/to-do.  When the task is complete, a cell within the row is Checked/True, or updated to 100% or Complete etc. 

When the progress cell within the row is updated, I'd like conditional formatting applied to all items within the row, to strike a line through everything and grey the colour of all text/items in the row. 

I've previously used Smart Sheets to do this and it worked brilliantly!  This helps to make the rows/tasks that are still live more visible.

Can the developers look to add this feature to conditional formatting please?

      Zoho SalesIQ Resources



            Zoho TeamInbox Resources

              Zoho DataPrep Resources


                  Zoho CRM Plus Resources

                    Zoho Books Resources


                      Zoho Subscriptions Resources

                        Zoho Desk Resources

                          Zoho Projects Resources


                            Zoho Sprints Resources


                              Qntrl Resources


                                Zoho Creator Resources


                                  Zoho WorkDrive Resources




                                      Zoho Campaigns Resources

                                        Zoho CRM Resources

                                                    Design. Discuss. Deliver.

                                                    Create visually engaging stories with Zoho Show.

                                                    Get Started Now


                                                      Zoho Show Resources


                                                        Zoho Writer Writer

                                                        Get Started. Write Away!

                                                        Writer is a powerful online word processor, designed for collaborative work.

                                                                  有料プランをご利用の方