Previous Topic Next Topic

Format based on another cell with a letter.

Closed
armnof - Jan 22, 2015 at 08:19 AM
 Blocked Profile - Jan 22, 2015 at 08:23 AM
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

Related:

1 reply

Answer 1 / 1
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.
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses
Duplicate rows based on cell value
fireburn -
TrowaD -

16 responses