• 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.

Change the Raw Color with status of a List

Lasantha

Member
Dear All,

Kindly look into the attached template. is it possible to change the raw color with status of a cell.

I need to change the color of raw ( B to I) with status of column I.

Kindly check the attachment for further details.

Thank you,
Lasantha,
 

Attachments

  • Template.xlsx
    9.1 KB · Views: 2
Select your range
Create the following CF : =$I2="WIP" and format accordingly
Do the same for the other values
To make sure the CF will follow when extending the range, organize your data as an Excel Table
 
Back
Top