•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Looking for workaround to achieve relative cell reference with 3-color scale conditioning formatting
Our take
Are you seeking a workaround for using relative cell references with 3-color scale conditional formatting in Excel? Specifically, you want to set a midpoint based on a calculated value in another cell while keeping the minimum and maximum as fixed numbers. Given the size of your spreadsheet, manually updating each reference is not ideal. This post invites solutions that can streamline your process without resorting to macros. Any insights or suggestions would be greatly appreciated as you tackle this challenge. Thank you!
This is literally my first Reddit post. Is there any work around, other than a macro, to use the 3-color scale conditional formatting in excel with the midpoint set as a relative cell reference? The minimum and maximum are hard numbers but I need the midpoint to reference a calculated value in a different cell and have that recalculated for each row? It’s a massive spreadsheet so I am trying to avoid having to manually change cell references for the mid point in each row. Hope that makes sense. Any help is greatly appreciated.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Conditional formatting in a single cell based on which interval it is inHi all I have a sheet where we log our machine hours (how many hours a specific machine has run for) I want to create a conditional formatting based on whether the machine has run 0-200 hours(green), 200-350 hours (yellow) or 350-500 hours (red) Hours will continually go up, so I'm either looking for a formula/formatting to recognise these intervals (eg 7250 = yellow, but also 8250=yellow), or only the fixed intervals but with a way to "reset" the counter after a service has been done to the machine. Hope this makes some sort of sense! submitted by /u/Askebon [link] [comments]
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
- Need to be able to use dashes or 0s in cells; getting error from excelI have a spreadsheet I'm working on where I need to be able to enter 0% as a value sometimes, and other times I need to be able to enter a dash as a way to indicated n/a. I can't figure out how to even enter a dash without getting a "don't leave cell empty, enter a 0" warning from excel. Is there a way to format this that will let me do either? I've tried playing with conditional formatting and custom cell formats but can't figure it out. Also does anyone know where that "don't leave this cell empty" error might be coming from? It will let me do zeroes and dashes in other cells, but this spreadsheet was given to me pre-made and I think they must have changed some setting on these cells that I don't know how to undo. Tried googling and got frustrated. submitted by /u/conditional_identity [link] [comments]
- Conditional formatting for highlighting cellsI have two very lengthy columns, let’s call them column A and column B. I need to highlight all of the cells in column B whose content does not appear in column A, but there are 80+ cells I’d have to check and it’d take me a really long time. I’m in no way an expert on excel but I do know I’d have to use conditional formatting, I just don’t know how to build the formula for this :( submitted by /u/Nandolvs [link] [comments]