conditional formatting for cell A1 based on value in cell A3

[rosefin01]

Hello! Requesting help for Conditional Formatting. Example in table below shows desired results. CAPITAL ONE is paid off in bottom table. When excel sees the a value higher than zero in the PAYOFF AMOUNT column I want the CREDITOR and PAYOFF AMOUNT cells to display with a red font.

[TABLE="width: 370"]
<tbody>[TR]
[TD="colspan: 5"]Current Looks like this[/TD]
[/TR]
[TR]
[TD]Creditor[/TD]
[TD]Present Balance[/TD]
[TD]Present Payment[/TD]
[TD]Payoff Amount[/TD]
[TD]Future Payment[/TD]
[/TR]
[TR]
[TD]Capital One[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Capital One[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]Want this to happen with conditional formatting[/TD]
[/TR]
[TR]
[TD]Creditor[/TD]
[TD]Present Balance[/TD]
[TD]Present Payment[/TD]
[TD]Payoff Amount[/TD]
[TD]Future Payment[/TD]
[/TR]
[TR]
[TD]Capital One[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Capital One[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]15[/TD]
[/TR]
</tbody>[/TABLE]
​

Thank you!

 

[Timjan]

Enter this formula in Conditional Formatting;

=IF(($B2=$D2),TRUE,FALSE)

Change Range to suit
Then in the "Applies to", the following;

=$A$2:$B$2,$D$2

Change Range to suit
Once done, select the first row of cells where this format applies to and drag it down as far as required.

 

[rosefin01]

Timjan - THANK YOU!!! ​

Works great! Exactly what I needed. All the best to you Timjan. :D​

 

[Peter_SSs]

Enter this formula in Conditional Formatting;

=IF(($B2=$D2),TRUE,FALSE)

Just to note: In Conditional Formatting you don't need the IF(...,TRUE,FALSE) as the logical test where I have ... is either TRUE OR FALSE. So this should do just as well

=$B2=$D2

 

[rosefin01]

Just to note: In Conditional Formatting you don't need the IF(...,TRUE,FALSE) as the logical test where I have ... is either TRUE OR FALSE. So this should do just as well

=$B2=$D2

Thank you, Peter!

 

[Peter_SSs]

Thank you, Peter!

No problem. Glad to contribute.