I have 3 values in separate cells... i am comparing 1 cell to 2 cells. Within a cell i can write =AND(D10>D9,D10>D8) and I get FALSE or TRUE depending on numbers
BUT if i use the same formula in Conditional Formatting it doesnt produce a colored condition... how can i apply a conditional formatting when comparing multiple cells to 1 cell?
thanks
BUT if i use the same formula in Conditional Formatting it doesnt produce a colored condition... how can i apply a conditional formatting when comparing multiple cells to 1 cell?
thanks