conditional coloring

[Krishna Mohan]

How can I fill the cells with different colors based on conditions

 

[LanceB]

Look at the format menu
Format -> Conditional formatting

 

[º¼ÖÝÈË]

format --conditional format