Hi, I wants to change the background colour of cell if there is a change in value in previous column cell.
I wants to apply this settings as horizontally in every row. Please Help !!!
PS: Please refer the attached file.
Hi, I wants to change the background colour of cell if there is a change in value in previous column cell.
I wants to apply this settings as horizontally in every row. Please Help !!!
PS: Please refer the attached file.
Not clear what you're asking.
For a specific row: do you want columns C:N to change colour (to match row 4), if the data in column B changes?
Or do you want Column C to change colour if column B changes, column D to change colour if column C changes, etc...?
What about if the values changes a second time? Should the colours change again, or only on first change?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
I wants to apply colour in column C to column N..... i.e if column D value is not equal to column C than apply different colour on column D. If column E is same as column D than apply the same colour of column D on column E and so on....!!
: Column B will be always different from column C.
Use something like:
Not clear how you want to call this - on worksheet change, perhaps, or as a one off loop through all rows?Please Login or Register to view this content.
To run once on existing data, use:
Please Login or Register to view this content.
Wowwww... !!! Your second code worked for me... thanks u so much OLLY...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks