tag:blogger.com,1999:blog-8807805591547673516.post1561264957098360172..comments2024-02-28T08:14:50.756-08:00Comments on Cloud Computing -- Google Docs Way: yogi_Apply Conditional Formatting To A Data Validated ListYogi Anandhttp://www.blogger.com/profile/10862524957172908621noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8807805591547673516.post-48460503693325585432013-01-07T13:33:28.559-08:002013-01-07T13:33:28.559-08:00any response yet on solution to conditional format...any response yet on solution to conditional formatting running automatically on new form entry cells?<br />thanks,<br />D.Daledemetridalehttps://www.blogger.com/profile/13192712648235571309noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-23954194328960043792012-07-10T05:35:38.378-07:002012-07-10T05:35:38.378-07:00Can I have some news about "Conditional Forma...Can I have some news about "Conditional Formatting" be updated on "Form submit" spreadsheet event?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-76023752183763364692011-07-03T12:43:07.783-07:002011-07-03T12:43:07.783-07:00Hi Luan:
One should not have to refresh/recalcula...Hi Luan:<br /><br />One should not have to refresh/recalculate the sheet for Conditional Formatting to work correctly -- so I have escalated this issue to Google Guides/Engineers for resolution. <br /><br />Cheers!<br />YogiYogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-64912289944056685752011-07-02T21:51:39.713-07:002011-07-02T21:51:39.713-07:00Hi Luan M:
Couple of things ...
1) instead of hid...Hi Luan M:<br /><br />Couple of things ...<br />1) instead of hiding the 4 value in the first column I filtered it out ... then on sorting column 1 in asceding or descending order, even though the values were sorted correctly, the coloring of the cells was not right ... see Sheet1a<br />2) however, the incorrect coloring of the cells got corrected when I refreshed the sheet for recalculating ... see Sheet1b<br /><br />I suggest you try my refreshing/recalculating suggestion and tell me if it then applies the Conditional Formatting correctly.<br /><br />Cheers!<br />YogiYogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.com