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

[Conditional Formatting] color 1 row same color, based on value in 1 cell of that row

Wilco()

Wilco()

Member
I have added my excel sheet.

It contains a "score sheet", where I want to automatically color each line same color. However scaled as it compares with cell E3.

I can do it for just column E, by using conditional formatting -> manage rules -> new rule -> Format all cells based on their values -> select format style 3 color.
But that is then for 1 cell. I want to have the same color for the row.

How to do this as simple as possible? As I have in my original sheet 3 other (same format) tables which need to have the same functionality.
 

Attachments

  • example.xlsx
    12.1 KB · Views: 7
If I'm understanding your question correctly, I take it you want the entire row formatted in the same way as the respective cell in Col E?
I've attached an example file, but the entire row is not formatted, merely range E10:E17.
 

Attachments

  • Wilco() CF example.xlsx
    11.6 KB · Views: 3
Thanks both, I used the great site Chirayu has posted. Great explanation. I got +1 on my Excel skills :awesome:

I like to colour grades in Excel, do not think it is possible to have something similar working. Unless to create my own color grade... manually :eek::(
 
You must log in or register to reply here.
Back
Top