Conditional Formatting Data Bars - Adjacent Cell

[BobG2166]

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.

 

[Saba Sabaratnam]

Hi

is that what you are looking for?

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

Apply conditional formatting as shown below with formulas.

Kind regards

Saba

 

[BobG2166]

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]

No problem

is this what you are looking for?

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.

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

Kind regards

Saba

 

[BobG2166]

Thanks Saba - This works great!

 

[Saba Sabaratnam]

Glad to help

Kind regards

Saba