Jul 26 2022 01:04 AM - edited Jul 26 2022 01:06 AM
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?
Jul 26 2022 01:15 AM
=AND(A1=Sheet2!A1,A1=50)
Does this rule for conditional formatting return your expected result?
Jul 26 2022 02:34 AM
Jul 26 2022 02:35 AM
Jul 26 2022 02:45 AM
Solution=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.
Jul 26 2022 04:56 AM
Sorry, file attached to previous post was not saved with final changes. Just in case it is here.
Jul 26 2022 02:45 AM
Solution=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.