PDA

View Full Version : Highlight 2 Cells Based on a text value(false)



kevinborlasa
03-17-2016, 11:21 PM
Hi to all Vba Experts,

I have some problems regarding this data in my worksheet, I need to automated the data below. This data is located on my worksheet along with other datas'.

If the Row of the Range has a false value the cell below the false should be highlight red if the value is negative and highlight red also the value above the false and highlight yellow if the value below the false is not negative same goes above the false.

I really need your help, I'm a newbie at vba. I appreciate all the help you can give me.


Column1
Column2
Column3
Column4
Column5


2097


$1,113,663.10




$15,846,046.50
$8,608,715.09
$8,157,864.13


Min
$973,159.84
$14,733,736.16
$10,008,761.85
$8,236,158.36


Max
$2,113,234.64
$27,967,913.45
$17,371,384.11
$15,854,343.35


Range
TRUE
TRUE
FALSE
FALSE


∆%


-13.99%
-0.95%