View original (French)

Conditional formatting

Solved
AgatheJzd Posted messages 6 Status Member -  
AgatheJzd Posted messages 6 Status Member -
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 Posted messages 3058 Registration date   Status Member Last intervention   479
     
    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
    0
    1. AgatheJzd Posted messages 6 Status Member
       
      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.
      0
  2. JCB40 Posted messages 3058 Registration date   Status Member Last intervention   479
     
    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
    0
    1. AgatheJzd Posted messages 6 Status Member
       
      Thank you very much, really!
      0
      1. JCB40 Posted messages 3058 Registration date   Status Member Last intervention   479 > AgatheJzd Posted messages 6 Status Member
         
        If that suits you, mark the issue as resolved
        Good luck
        0
      2. AgatheJzd Posted messages 6 Status Member > JCB40 Posted messages 3058 Registration date   Status Member Last intervention  
         
        Yes, thank you, I will get back to you if needed :)
        0