MID funtion with conditional format

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 formatting excel 2003 2
Conditional Formating with IF and AND formula 2
Conditional Formating and Mid 2
Conditional Formatting 6
Conditional Formatting 4
Conditional formatting 1
Conditional Format - How to View??? 1

Top