Aug 02 2022 08:07 AM
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.
Aug 03 2022 12:19 AM - edited Aug 03 2022 12:20 AM
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.