tag:blogger.com,1999:blog-8807805591547673516.post5208717251844560832..comments2024-02-28T08:14:50.756-08:00Comments on Cloud Computing -- Google Docs Way: yogi_Apply Conditional Formatting To Project Completion Column Based On Values Of Cells In Other ColumnsYogi Anandhttp://www.blogger.com/profile/10862524957172908621noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-8807805591547673516.post-13435531979084659402012-08-06T15:17:22.232-07:002012-08-06T15:17:22.232-07:00Hi DeLiK:
Please share your spreadsheet with some...Hi DeLiK:<br /><br />Please share your spreadsheet with some sample and realistic data, then <br />1) tell me what you are trying tp accomplish <br /> in which cell?<br /> of which sheet?<br />2) show me what is your expected result<br /> along with needed logic/explanation<br />3) are you open to considering a workaround?<br /> are you open to having a helper column added?<br /><br />Cheers!<br />Yogi<br />Cloud Computing -- Google Docs Way<br />yogi--anand-consulting.blogspot.comYogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-31138041835782324632012-08-06T13:16:13.235-07:002012-08-06T13:16:13.235-07:00The problem is,
What if you want to make the colo...The problem is,<br /><br />What if you want to make the coloured cell available to fill with some other value?<br />For instance,<br />"If the value of the cell A1 is "Sunday" the cells A2:A10 will be grey"<br />And in the column A2:A10 I need to fill with notes and appointments, each row is one hour of that day.DeLiKhttps://www.blogger.com/profile/15178506059139098818noreply@blogger.com