Forum Discussion

ateliersbacha's avatar
ateliersbacha
Copper Contributor
Aug 12, 2024

2 Conditional Formatting in 1 cell

Hi!

 

How can I apply 2 conditional formatting to 1 cell at the same time?

I mean if they both are overlapping in 1 cell i want it to show the color and the border line?

 

 

  • mathetes's avatar
    mathetes
    Silver Contributor
    Write an additional rule that combines both conditions and both formats
    • ateliersbacha's avatar
      ateliersbacha
      Copper Contributor

      mathetes 

      Thank you for your reply, I was thinking about that but in that case It will not be linked to the start and finish dates and words that i need to see in the spreadsheet

      • mathetes's avatar
        mathetes
        Silver Contributor
        I'm not following. Sounds like you're adding additional conditions. In any event, far more helpful than an image would be a copy of your actual workbook (or a mockup if the actual contains confidential info). Post it on OneDrive or GoogleDrive with a link here that grants edit access.

Resources