Doing some high quantity spreadsheet validations. Wondering if there is a way to populate a cell in column D with a predefined text ("Enabled") if the cell next to it is bolded. I went through and bolded them all with a duplicate conditional formatting procedure and pasted the output over to the master spreadsheet. Now I just need a column with the text that matches so I can filter on it. Any help would be awesome. Thank you so much.
Press Ctrl+F3 to bring up the Name Manager. Press new, name it
In the column you want "enabled" to appear in for bolded cells, type in