MID funtion with conditional format

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

i am trying to use MID function as formula in conditional format -
=MID(C9,5,1)=X

if the 5th char of cell C9 is the letter "X", then i want to apply color to
the cell as my conditional format.

can't get the formula to work....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Conditional Formating and Mid 2
Conditional Formatting 6
Conditional Formatting: different fonts colors for the same text 4
Conditional Formatting? 3
Negative Conditional Formatting Excel 2003 2
Excel 2007 - A Conditional Formatting ?'s 1
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2

Back
Top