You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
-
Cheers but I'm looking for something a bit more advanced than that (the real data has shitloads of products) and they'll vary when I refresh. I want it to automatically detect when there is a change in that column.
I've done it before (although I remember it being processor intensive) but cannot remember how.
Edit: This version with a helper column works but I'm sure I had something more stylish
1 Attachment
-
aggi
Click on the Conditional Formatting icon
Click on New Rule option
In the New Formatting Rule dialog box, select – “Use a formula to determine which cells to format” option
Enter the following formula in the field:
something like
if a = "A"
https://techcommunity.microsoft.com/t5/excel/conditional-formatting-and-power-query/m-p/1343631
for power query?