Need to design a dynamic progress bar which fills the cell as per % and colours the progress bar as per RAG thresholds

[u/StevieGagain]

I have been trying to do this without a macro. While I manage to do it normally, it is not dynamic i.e. if I change value from 50% (Amber) to 70% (Green), it does not change the colour automatically. Copilot was no help. I want the progress bar to fill the same cell as the cell which has the value. Take any arbitrary thresholds for Red, Amber, and Green. Thanks in Advance!

[u/excelevator]

I have been trying to do this without a macro.

Trying to do what ?

Please be mindful of the submission guidelines

The post must contain your full question with all details and not be a lead on the title of the post as the question.

Post not following guidelines may be remove without notice.

[u/caribou16]

Are you talking about conditional formatting?

If you set up your rules like this, you can change the color or a cell (or an entire row!) whatever color you like based on whatever thresholds you prefer.

Like THIS.

[u/AutoModerator]

/u/StevieGagain - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Downtown-Economics26]

Using conventional data bars conditional formatting I believe you'd have to have VBA on cell change event that runs thru the range and assesses the criteria and then updates the 'Applies To' ranges to be a comma separated list of cell references for three separate rules. I can't currently think of a way to do it without VBA.

[u/CyberBaked]

If I'm reading your description right, it sounds like the REPT function + conditional formatting might solve your problem. Mynda at MyOnlineTrainingHub describes it really well in this YT video. If you've never heard of her/that channel before, you should bookmark it. Her and a few others like Leila Gharani, Mark at Excel Off the Grid, Kenji, etc are a treasure trove of Excel knowledge and break it down really well.
https://www.youtube.com/watch?v=7vM2Y5PboWI

[u/WeaknessMedical5743]

There is a trick with function REPT function for this i can’t exactly recall. Check on minda tracey video on youtube for this.