.--------------------------------------------------------------------------------------------------------------------------.
.
.
.
.
Update…11/16/2017
Not sure what is going on or what I am doing wrong, but very frustrating. I duplicate suggestions and nothing happens… past week I downloaded new version of LO thinking this maybe the problem but its not…
see new pic and file with Conditional Formatting .
.
.
Anyone? …
I think I got confused. Do you want each cell in column E to be red if it is greater than any column F value, that is, the maximum value of column F?
So that each cell in column E is color green if it is less of any value in column G, that is, of the minimum value of column F?
Yes, Ty Charlie
Each cell in column E to be red if it is greater than any CELL in column F value, that is, the maximum value of column F? So that each cell in column E is color green if it is less of any CELL value in column G, that is, of the minimum value of column F?
Because there are not values on E greater than the maximum value on F, that is way I changed on the sample some values on E to verify CF was working fine.
Ciao, see my attachment please.
If my answer helped you, vote it with 
(here on the left)
Edit:I am sorry, I’m wrong in copy and paste. Replace F18:F115 with $F$18:$F$115 and G18:G115 with $G$18:$G$115.
Edit ----------------------------------------------------------------------------------------
End Edit -----------------------------------------------------------------------------------
Thank you,
I understand Cell Value is … pertaining to another cell… What i was looking for, to show if each Cell in
column E if Greater than the value in any cell within column F (F18::F115) it will turn RED and less than any cell within Column G (G18::G115) it will turn Green.
EXAMPLE: E18 will scan all of (F18::F115) and (G18::G115) if Greater than F column it will turn RED if less than column G it will turn Green and so on
then next cell E19 will do the same… next cell E20…
Thank you for the update file…
I tried this before posting…
when i uploaded file i see not conditional format changes to the cells in column E
example what I would like to see…
Column E Row 93 159.79 should be Green since it is less than Column G Row 98
I am sorry, I’m wrong in copy and paste. Replace F18:F115 with $F$18:$F$115 and G18:G115 with $G$18:$G$115.
thank you for the feedback, i tried this before posting.
would u be able to provide .ods that shows conditional format?
all attempts on my side have failed. please show screen shot of conditional format if possible
I think I got confused. Do you want each cell in column E to be red if it is greater than any column F value, that is, the maximum value of column F? So that each cell in column E is color green if it is less of any value in column G, that is, of the minimum value of column F?
Yes, Ty Charlie
Each cell in column E to be red if it is greater than any CELL in column F value, that is, the maximum value of column F? So that each cell in column E is color green if it is less of any CELL value in column G, that is, of the minimum value of column F?
Doing the comparison against the MAX($F$6:$F$43) and MIN($G$6:$G$43), and can be done for all cells at once, instead one by one with the cell range.
15077558367905342.ods
Some values was change to have some cells with the CF condition.
