LinkBack URL
About LinkBacks
Hi, here is my code, the problematic line is this: "if cell.value = "".. if TRUE I want Excel to color the entire row, isn't the way to look for empty cell?
Please Login or Register to view this content.
Hi, here is my code, the problematic line is this: "if cell.value = "".. if TRUE I want Excel to color the entire row, isn't the way to look for empty cell?
Please Login or Register to view this content.
Please * if you like the answer
Assuming the blanks are not as a result of a formula.Please Login or Register to view this content.
So you're trying to set font to green for all rows which contain a blank cell within the used range, right?
This works for me...Please Login or Register to view this content.
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...
Is the code not working? I tested it and it worked.
@yudlugar thanks. Where in my code should I add your line?
Replace it all:
Although if your code didn't work that probably won't either, are you sure they are blank and not a space or something? An example workbook might be helpful in this case.Please Login or Register to view this content.
Thanks guys it works now..and I learnt somthing new.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks