1. Select the cell/Range (say N34:N44).
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=ISTEXT($M$32)
4. Click Format Button>Pattern and select your color (say Yellow)
5. Hit OK
PS: If you are using XL2007 Goto Home tab>Styles>Conditional
Formatting>Manage rules>New rule>Use a formula to determine which cells to
format. Enter the formula in the box below.
Format > Conditional Formatting > Formula Is =$M$32<>""
Click Format and choose you’re the properties of your format and hit OK
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.