Forum Discussion

ajl_ahmed's avatar
ajl_ahmed
Iron Contributor
Jul 26, 2022
Solved

Conditional formatting

Hi what is the fastest way to conditional formatting once time the cells of Sheet 2 Range (A1:N35) based on the corresponding cell value of sheet 3 Range (A1:N35) such that if the cell in sheet 3 (F...
excel
Formulas and Functions
office 365
  • OliverScheurich's avatar
    OliverScheurich
    Jul 26, 2022

    ajl_ahmed 

    =AND(A1=Sheet3!A1,A1=50)

    This rule for conditional formatting should do what you are looking for. In my first post i accidentally suggested a rule which formats sheet3 instead of sheet2.

     

  • ajl_ahmed's avatar
    ajl_ahmed
    Iron Contributor
    Jul 26, 2022
    Does this formula format the cell in sheet 2 with respect to the value of the corresponding cell in sheet 3 if its value is equal to 50? to explain more;
    - The cell M10 in sheet 3 is equal to 50 so I need the cell M10 in sheet 2 with black fill and white font.
    - The cell L9 in sheet 3 is equal to nothing so Ino formatting is needed to do in cell L9 in sheet 2 .

Resources