You are reading a single comment by @user16171 and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@user16171
I have a sheet with component id's as rows and component features as columns.
I would like a conditional format that returns a colour and a COMPLETE where there is a text entry in each component feature column.
So the line item under RAG shows as COMPLETE when the component has an entry for each cell in the row.
1 Attachment