Given the setup as shown in the attachment. When an item is selected from the dropdown list I want to strike through the item in the display area. I am not sure how to write the formula to accomplish this.
Jim O
Given the setup as shown in the attachment. When an item is selected from the dropdown list I want to strike through the item in the display area. I am not sure how to write the formula to accomplish this.
Jim O
Last edited by JO505; 10-10-2013 at 12:34 PM.
Hello
Apply the following Conditional Formatting formula to the required cells:
Then select Strike-through from the Format selection.Please Login or Register to view this content.
Hope this helps.
DBY
Use the following conditional formatting formula:
Formula:Please Login or Register to view this content.
Apply strikethrough formatting based on this condition.
Apply this formatting to cells L2:L7, N2:N7, P2:P7.
Remove any existing strikethrough formatting.
Fixed file attached.
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...
Thank you both for the response. It works great!
Jim O
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks