3 ms·
Sad I didn't see this earlier. Would love to see a couple issues addressed in spreadsheets. Namely conditional formatting based on a formula and merging of cell
by orofino 15y ago
Sad I didn't see this earlier. Would love to see a couple issues addressed in spreadsheets. Namely conditional formatting based on a formula and merging of cells vertically.
- gruseom 15y agoWhat do you like to use conditional formatting for?
- Flenser 15y agoConditional formatting based on a formula is great for highlighting cells with values that don't make semantic sense.
- orofino 15y agoFormatting like this is helpful for things like... if cell < 0 make entire row red This isn't currently possible because the conditional can only check the value of THIS cell, not others. As the other comment indicates, it also helps expand what values you can evaluate. I use excel heavily and this is one of the largest gaps between it and google docs for me.
- gruseom 15y agoI work on this kind of thing (not at Google) and your answer here is helpful. If you'd be up for an offline discussion about other gaps between Excel and web-based spreadsheets, please email me (address in profile).