Format based on another cell with a letter.

armnof - Jan 22, 2015 at 08:19 AM
 Blocked Profile - Jan 22, 2015 at 08:23 AM

I would like to know if there is a way to apply a format formula to a cell but to use a letter as criteria instead of a number?



I've tried to use this formula but it seems to be working with numeric values only.



1 response

Blocked Profile
Jan 22, 2015 at 08:23 AM
OK, so put some QUOTES around the letter (like "A").

So your formula is =D3+"A".

Post a picture of what you are trying to accomplish if this doesn't help.