Conditional Formatting Data Bars - Adjacent Cell

BobG2166

New Member
Joined
Jul 13, 2012
Messages
9
I would like to create a conditional formatting data bar next to the cell with the value. For example, if cell E1 is -250,000 then cell F1 will be red and if cell E2 is +125,000 then cell F2 would be green. I would like this to be on a gradient as one can accomplish in a data bar within the cell that has the value.

Thanks in advance.
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Saba Sabaratnam

Board Regular
Joined
May 26, 2018
Messages
121
Hi

is that what you are looking for?

1583807022603.png


If so, format cells, B1-B18 with three semicolons in a row as shown below

1583807090185.png


Apply conditional formatting as shown below with formulas.

1583807150367.png


Kind regards

Saba
 

BobG2166

New Member
Joined
Jul 13, 2012
Messages
9
Thanks for the help. Can this be modified so that it is similar to a data bar where the negative (red) would be on the left of the bar and the positive (green) would be on the right side?
 

Saba Sabaratnam

Board Regular
Joined
May 26, 2018
Messages
121
No problem

is this what you are looking for?

1583883734085.png


if so,

Enter the following formula in B1 and copy it down to B18

=IF(A1<0,A1,"")

Enter the following formula in C1 and copy it down to C18

=IF(A1>=0,A1,"")


Format both Column B and C with the three semicolons as shown below.


1583807090185.png


Apply conditional formatting as shown below with formulas both in Column B (from B1 to B18) and C ( from C1 to C18)

1583807150367.png


Kind regards

Saba
 

Watch MrExcel Video

Forum statistics

Threads
1,113,904
Messages
5,544,978
Members
410,647
Latest member
LegenDSlayeR
Top