Excel: Conditional formatting based on another cell.
Solved
Peu importe
-
Intrus -
Intrus -
Hi! I’m really struggling with a function I'm trying to implement in Excel 2002.
I would really appreciate it if you could accommodate my request. Here's what I would like to do: apply a specific format (red, bold, etc.) to a cell based on the value (a letter, not a number) of an adjacent cell.
Could someone help me achieve this feat? (for me)
Do I need to use a defined function or a macro?
Thanks a lot!
I would really appreciate it if you could accommodate my request. Here's what I would like to do: apply a specific format (red, bold, etc.) to a cell based on the value (a letter, not a number) of an adjacent cell.
Could someone help me achieve this feat? (for me)
Do I need to use a defined function or a macro?
Thanks a lot!
2 answers
Hi,
for that you just need to use conditional formatting
select cell B1 for example
from the menu "format - conditional formatting.."
in the drop-down list select "the formula is" and the condition for example =A1="A" then the format you want
this will allow you to give a color to cell B if you've typed an A in cell A1
there you go, that's all
for that you just need to use conditional formatting
select cell B1 for example
from the menu "format - conditional formatting.."
in the drop-down list select "the formula is" and the condition for example =A1="A" then the format you want
this will allow you to give a color to cell B if you've typed an A in cell A1
there you go, that's all
This is the second time I am consulting this question and trying to implement it.
- The first time: it was a complete failure
- today: it started to act randomly! (notably adding " " where I had already placed them..... then after several attempts, it worked.
Your sentence is simple and precise. So it is necessary to insist to succeed.
.
As for me, I wanted several cells following cell A1 to be conditionally formatted. So I added a $ to write $A1, and it worked.