Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 0 down vote favorite

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.

share|improve this question
Which version of Excel? Is the condition formatting something that could be expressed in a formula, e.g. =if(and(cell> minimum,cell<maximum),"Enabled","") – paulmorriss Mar 21 '11 at 17:27
2010....hmm. I am not sure, I will see if that might work. Thanks! – Rob Hilliard Mar 21 '11 at 18:25
If it does, please comment here so that I can "answer" the question properly. – paulmorriss Mar 22 '11 at 9:03

1 Answer

up vote 0 down vote

Press Ctrl+F3 to bring up the Name Manager. Press new, name it ifbold and put in the refers to box =if(GET.CELL(20,!$D1),"Enabled,"")

In the column you want "enabled" to appear in for bolded cells, type in =ifbold and drag it down. It will enter "enabled" into any cell where the matching cell in column D is bold. If it doesn't update hit F9

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.