SOLVED

Contributor

# 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 (F26), for example, is equal to 50 then the conditional formatting of the cell (F26) in sheet 2 is filled with black color and text line is bold and white? can you explain the steps here in details?

7 Replies

# Re: Conditional formatting

``=AND(A1=Sheet2!A1,A1=50)``

Does this rule for conditional formatting return your expected result?

It could be like

# Re: Conditional formatting

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 .

# Re: Conditional formatting

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 .
best response confirmed by ajl_ahmed (Contributor)
Solution

# Re: Conditional formatting

``=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.

Thanks

# Re: Conditional formatting

Sorry, file attached to previous post was not saved with final changes. Just in case it is here.