Forum Discussion

Deleted's avatar
Deleted
Feb 14, 2018

Conditional Formatting based on a formula in 2 other Columns

Dear experts,

 

I want to add a Data Bar in the YTD (Year To Data) spend column. I do not have enough space in the table so want to use the Data Bar to reflect the burn rate vs Plan.

 

So, in the below example the Data Bar in column E, which is based on the formula column B / column C, should be shown in the YTD cells.

 

Any help is appreciated!

 

Kind regards, Oscar

No Replies