Format based on another cell with a letter. Closed

Question

Hello, 

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?

Example:

=D3=A

I've tried to use this formula but it seems to be working with numeric values only.

Thanks

Configuration: Windows 7 / Mozilla 11.0

ac3mark · Answer

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.

Format based on another cell with a letter.

1 response

Similar discussions

Subscribe To Our Newsletter!