• 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 from column to colum

Lawrence429

New Member
Hello all my Excel geniuses:)
I am tracking what tool is used each day. I have a cell that I put a tool ID number in everyday, if the tool changes the number changes and I would like the cell to change color if it is different from the cell in the previous column.
(There are actually 38 different machines all listed in column B that I need to compare with the previous day. If I can figure out how to do one row, I assume it would be copy the formula down to all rows below).
thank you in advance
Lawrence
PS if VBA is preferred, please share the text as I am not that good with VBA
 
Please review the "test -- compare columns" file. I manually highlighted in yellow what I would like Excel to display daily. I only want a cell highlighted IF it does not match the cell directly to the left.
thanks again.
 

Attachments

  • test -- compare columns.xlsx
    9.4 KB · Views: 4
simply put this in your CF formula and apply it to the correct range.
upload_2019-1-14_20-48-18.png
 

Attachments

  • Copy of test -- compare columns.xlsx
    9.5 KB · Views: 3
Lawrence429
If 'each day' means 'many days' eg longer than one year
then You would use this.
( I'll explain details after You'll try to use this )
 

Attachments

  • test -- compare columns.xlsb
    14.2 KB · Views: 6
Lawrence429
If 'each day' means 'many days' eg longer than one year
then You would use this.
( I'll explain details after You'll try to use this )
Hi vletm --
Thank you for your help. Why did you choose to transpose the column / rows? I didn't see any formatting or equations, where did you hide them?
 
Lawrence429
Why? ...
As I wrote:
If 'each day' means 'many days' eg longer than one year
then You would use this.

If You'll use it over week ... over one month ... over six month
then there should be more dates than those 'others'.
Have You thought, how would Your version look eg one year later?
For me, it's much normal to scroll rows than columns.
... and my row scrollbar is longer than scrollbar for columns.
Transport:
I used a short code to do it ... then there won't need those.
... as well as
those marks colors would work as long as needed, without eg modify CF-range.
There is a code for that too.
It works after You've changed cells value; it'll compare above cells value.
 
Back
Top