hello everyone,
so I have a question if its possible for excel to read background color of active cell, and to preform that function if the cell is colored.
As of know my function in excel looks like this =IF(AND(K11="S-1",B11="blue"),J11, ). Is there anyway to replace B11=" Blue" to just read background color of the active cell which would be in Q11, and if it RGB (0,176,240) and K11="S-1" to just copy J11 number to active cell.
so I have a question if its possible for excel to read background color of active cell, and to preform that function if the cell is colored.
As of know my function in excel looks like this =IF(AND(K11="S-1",B11="blue"),J11, ). Is there anyway to replace B11=" Blue" to just read background color of the active cell which would be in Q11, and if it RGB (0,176,240) and K11="S-1" to just copy J11 number to active cell.