Link to home
Create AccountLog in
Avatar of vegas86
vegas86

asked on

Conditional Formatting Excel 2010

Hello,

I am hoping someone can help me with the following problem I am having with conditional formatting.
Basically I am using the formula based formatting with the formula being:
=AND(O$11>=$K12,O$11<=$L12)

however, I don't want to use a colour to shade the cells I actually want to use a letter.
Can this be done?

So for example, instead of picking orange as a 'fill' I want to use the letter 'M'


Any help will be greatly appreciated!!

Thank you!!
ASKER CERTIFIED SOLUTION
Avatar of nand633
nand633

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of vegas86
vegas86

ASKER

Thank you both so much for your quick replies! I didnt even think to just do the formula in the cells along with the conditonal formatting! I really appreciate your help!