• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

jack abbey

New Member
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
 
works perfect
many thanks

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

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

Plz like if your find this helpful.
 
Back
Top