Data Bars on Formula Results

Occasional Visitor

As the title says, I've a formula that assings a value from 1 to 5 from a column X so values are easier to manage.

 

Problem is, when I try to apply data bars format on the 1 to 5 formula results, data bars aren't showing.

1 Reply

Hi @DomySalv1475 

 

is the result of the formula really a number or is it a text that looks like a number? What is the number format in the cells?

Maybe you can let us know the formula that you are using in these cells and provide a screenshot.