Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I read your question and I don't think the given answer is the best way to achieve what you want. There is a far more easy solution to solve your problem.

  • Open your spreadsheet and place the cursor on the cell that requires conditional formatting.
  • Go to the menu: Format > Conditional Formatting > Manage
  • Click button 'Add'
  • It already says "Cell value is equal to". In the field on the right you type "OK" (including the quotes)
  • On the next line it says "Apply Style". Use the drop-down menu to select your green style
  • Click the 'Add' button again.
  • Again it says "Cell value is equal to". In the field on the right you type "CHANGE" (including the quotes)
  • On the next line use the drop-down menu again, this time to select your red style
  • Click the 'OK' button and you're done

THIS is the correct way to set-up conditional formatting. You can apply one "rule" not only to 1 specific cell, but to a whole range of cells simply by adjusting the cell range.

Hope this will help you. It's a far more efficent way to implement conditional formatting.