For example: Formula: =O27>45 -> Format red So I've tried asking a professional on Excelchat and they told me the only answer they had for me was to conditionally format each cell with the cell location in a formula. The only cells that I get highlighted green are the ones that are empty and don't have anything in them. When I put this conditional format however, it gives me all the cells as red, even though they are less than 45. As I said above, if the number is greater than 45, red, less than or equal to 45, green. Now, in sheet1, I am trying to conditionally format that cell and many other cells that are pulling the exact same formula (with different numbers though). Kind of a mess, but pretty much what it is doing is looking through a table row and finding the most recent value that was inputed, and it is avoiding any cells in that row that have an *. The cell that it references in sheet2 (called RIGHTCENTER) has the following formula: =SUBSTITUTE(HLOOKUP(G3,Table25891314151834051,A10,FALSE),"*","") Simple, just referencing a cell from another sheet. A cell in sheet1 (called cycles) has the following formula: =RIGHTCENTER!F10 All these cells are referenced from other sheets. If it is less than or equal to 45, highlight green. I have current a bunch of cells that need conditional formatting. I am trying to set up some conditional formatting on an assignment and it just isn't working properly.
0 kommentar(er)
