• 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

S

Shabbo

Member
Dear Sir,

I wanted to Apply Conditional Formatting with comparing column to column.

  • I wanted to compare Column A with Column B
  • If the Value in Column A is greater than Column B then Up Arrow with brown Color.
  • If the Value in Column A is lesser than Column B then Down Arrow with Blue Color
  • If the Value in Column A is greater than Column B with more than 20% then Up-arrow with Red Color.
Can you please help.
 

Attachments

  • Value Compare.xlsx
    11.5 KB · Views: 3

Shabbo​

My Excel gives one minor note ...
but could You use something like this?
 

Attachments

  • Value Compare.xlsx
    38.9 KB · Views: 5
You must log in or register to reply here.
Back
Top