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

Fill Cell Color Based on < or > Compared to Another Cell

BL84

BL84

Member
Excel Color 50-64.png
I need 1 formula. It will fit all columns. Here's what it needs to accomplish. Example = If C1 is < than C50 (Last Number) the cell will fill "blue".
If C1 is > than C50 (Last Number) the cell will fill "Pink". All numbers change frequently, that's why I need C50 not 3.05 in the formula.
Hope this is enough info. If more info needed, I'll be happy to supply.

Thanks,

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