# Conditional Format Column (updated) 10-16-2017 [closed]

.--------------------------------------------------------------------------------------------------------------------------. . . . . 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 . . . . . C:\fakepath\Conditional Format Columns 10-16-2017 Not Working.ods . . . . .

edit retag reopen merge delete

### Closed for the following reason question is not relevant or outdated by Alex Kemp close date 2020-10-17 21:43:38.492705

Anyone? ..

( 2017-10-11 06:02:49 +0200 )edit

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?

( 2017-10-12 07:53:12 +0200 )edit

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?

( 2017-10-13 18:46:43 +0200 )edit

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.

( 2017-10-16 22:17:35 +0200 )edit

Sort by » oldest newest most voted

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.

more

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 ----------------------------------------------------------------------------------------


NewFile.ods

End Edit -----------------------------------------------------------------------------------


15076581288654682.ods

more

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...

( 2017-10-11 14:39:23 +0200 )edit

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

( 2017-10-11 16:07:53 +0200 )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.

( 2017-10-11 17:27:07 +0200 )edit

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

( 2017-10-11 18:51:16 +0200 )edit

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?

( 2017-10-12 19:03:50 +0200 )edit

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?

( 2017-10-13 18:49:14 +0200 )edit

## Stats

Asked: 2017-10-10 19:55:37 +0200

Seen: 121 times

Last updated: Oct 16 '17