I have rows of cells, some cells with a background color or fill, some not. The fill in any case is always the same color. (lets say orange)
(Cells A1:M1 may be blank and N1:S1 may have fill. Where the cells are blank or have fill is different for every row.)
In a cell within a row, if the letter F was entered and the fill/color was blank, I want a cell at the end of the row (a column at the end of all rows)to be red.
In a cell within a row, if the letter F was entered and the fill/color was orange, I want a cell at the end of the row (a column at the end of all rows) to be green.
Thanks if you can solve this.
(Cells A1:M1 may be blank and N1:S1 may have fill. Where the cells are blank or have fill is different for every row.)
In a cell within a row, if the letter F was entered and the fill/color was blank, I want a cell at the end of the row (a column at the end of all rows)to be red.
In a cell within a row, if the letter F was entered and the fill/color was orange, I want a cell at the end of the row (a column at the end of all rows) to be green.
Thanks if you can solve this.