I am trying to create rule that given a row of data: (1,1,3,6,6,6,7,1,2,2,2) How do I make a cell light up if it is a different value than the one preceding it. If Ican extend this row rule to an entire table that would be great too.
Thanks!
I am trying to create rule that given a row of data: (1,1,3,6,6,6,7,1,2,2,2) How do I make a cell light up if it is a different value than the one preceding it. If Ican extend this row rule to an entire table that would be great too.
Thanks!
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hello Sixthsense!
Attached is a sample work book. On the BEFORE you see under column A a percentage of a lease. I am trying to track changes in ownership of lease over years. So starting at B8 the formula would read to the right and as soon as there is a change in value it lights up, as shown on the AFTER workbook. I would like to formula to not just show a change in original ownership but to recognize the new value as the one it compares the following cell against.
Thank you so much for any advice or help!
Place the cursor in C8 Cell and extend your selection upto AH12. Activecell should be C8 cell.
Create CF using the below formula
=AND($B8<>C8,COUNTIF($C8:C8,C8)=1)
Refer the attached file
Last edited by :) Sixthsense :); 11-18-2014 at 03:49 AM.
Thank you Sixthsense Guru you are the best!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks