• 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 row font color based on the content of one cell in that particular row

A

Ajit

New Member
I have an issue. This is regarding the planning of the material .I have a work sheet with data with font color red. In one of the cells along the column if I type ‘RECEIVED’, the color of the entire row should change to black color.Is it possible ,please suggest.
 
Dear Ajit,


You can use conditional formating for this.Assume that you have data in A1:E1 (SingleRow),

if you will type "RECEIVED" in E1, then entire row (A1:E1) will be changed to RED color. By this in conditional formating, click new rule, and then click use formula to determine which cells to format in formula box enter =$E1="RECEIVED" and then click format, and then click Fill Tab and select RED color and then press ok.ok. Thats it you have done. Now you can check by entering "RECEIVED" in cell E1.


Thanks

Vijay
 
You must log in or register to reply here.
Back
Top