Re:We're five members of the Google Docs team - ask us anything
by gruseom on Monday June 13, 2011 @11:21PM
(#2651682)
What do you like to use conditional formatting for?
[ Parent
| on HN ]
Re:We're five members of the Google Docs team - ask us anything
by orofino on Tuesday June 14, 2011 @09:33AM
(#2652865)
Formatting 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.
Re:We're five members of the Google Docs team - ask us anything
by gruseom on Tuesday June 14, 2011 @11:36AM
(#2653432)
I 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).