conditional formatting for cell A1 based on value in cell A3

rosefin01

New Member
Joined
Feb 13, 2013
Messages
17
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.

Current Looks like this
CreditorPresent BalancePresent PaymentPayoff AmountFuture Payment
Capital One10001510000
Capital One100015015
Want this to happen with conditional formatting
CreditorPresent BalancePresent PaymentPayoff AmountFuture Payment
Capital One10001510000
Capital One100015015

<tbody>
</tbody>

Thank you!

 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Timjan

Board Regular
Joined
Oct 5, 2016
Messages
63
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.
 
Last edited:

rosefin01

New Member
Joined
Feb 13, 2013
Messages
17
Timjan - THANK YOU!!!
:cool:
Works great! Exactly what I needed. All the best to you Timjan. :D
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,712
Office Version
365
Platform
Windows
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

Code:
=$B2=$D2
 

Watch MrExcel Video

Forum statistics

Threads
1,099,566
Messages
5,469,448
Members
406,652
Latest member
LJA

This Week's Hot Topics

Top