how do i color-code the cells/rows according to the cell values?

[jack abbey]

how do i color-code the cells/rows according to the cell values?
for example, if the cell value equals 2 then it the cell color should be Red, else it should stay the neutral color
or if the cell value is "London" then the Row should be color Yellow

 

[Belleke]

See the rules in conditional format.

 

[jack abbey]

works perfect
many thanks

however, how to i change the color of the entire row according to a cell value condition?

 

[Belleke]

Like this?
See the rules in conditional format.

 

[jack abbey]

thanks for your reply
it does not seem to work by me
can you kindly explain to me the main steps?

 

[Irfan Aman]

Hi Jack,

you can manage it through conditional formatting.
The below image may guide you with step by step procedure:


Plz like if your find this helpful.

 

[jack abbey]

thanks
works amazing