View original (French)

Excel: Conditional formatting based on another cell.

Solved
Peu importe -  
 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!

2 answers

  1. manu-39
     
    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
    69
    1. Pascal
       
      Thank you manu-39.
      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.
      3
    2. yoyo789
       
      Thank you +44
      0
    3. yoyo789
       
      Thank you, Manu-39
      0
    4. Intrus
       
      Yes, thank you!
      0