View original (French)

Conditional formatting

Solved
AgatheJzd -  
Hello,

I am in the process of creating a sort of form and I'm stuck on a formula/formatting issue.

It seems simple, but I've been stuck on it for a little while now..

--> If I have a cell X that is empty, I would like the text in cell Y to be strikethrough.


So far I have tried using the IF(ISBLANK) formula and conditional formatting, but I always get stuck when it comes to striking through the text in the other cell.

Thank you in advance for your help,
Best regards,

Agathe J.

2 answers

  1.  JCB40
    Hello
    An example
    https://www.cjoint.com/c/JKrmLmNha3J
    Best regards

    --
    Start by doing what is necessary, then do what is possible, and you will achieve the impossible without realizing it. Saint Francis of Assisi
    1. AgatheJzd Author
      Thank you very much for your quick reply!

      One last question, I successfully applied conditional formatting when I only select a single data range. However, I am having trouble when I need to select multiple data ranges. Each time I do, I get the following error message: "You must not use reference operators (such as unions, intersections, and ranges) or array constants for the criteria in conditional formatting."

      So far, I was separating my data ranges with a semicolon; how can I overcome this problem?
      Indeed, I need several different cells to be empty for my condition to be met.

      Thank you in advance and have a great day,
      Agathe J.
  2. JCB40
    Re
    Formula to put in the MFC and adapt to your needs

    =AND($A1="", $B1="", $C1="")

    --
    Start by doing what is necessary, then do what is possible, and you will achieve the impossible without realizing it. Saint Francis of Assisi
    1. AgatheJzd Author
      Thank you very much, really!
    2. JCB40
      @AgatheJzdIf that suits you, mark the issue as resolved
      Good luck
    3. AgatheJzd Author
      @JCB40Yes, thank you, I will get back to you if needed :)