4 ms·
What do you like to use conditional formatting for?
by gruseom 15y ago
What 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).