Ask Your Question
0

Conditional Format Column (updated) 10-16-2017

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

JG101 gravatar image

updated 2017-10-16 14:28:12 +0200

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

edit retag flag offensive close merge delete

Comments

Anyone? ..

JG101 gravatar imageJG101 ( 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?

charlie.it gravatar imagecharlie.it ( 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?

JG101 gravatar imageJG101 ( 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.

m.a.riosv gravatar imagem.a.riosv ( 2017-10-16 22:17:35 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2017-10-13 19:21:01 +0200

m.a.riosv gravatar image

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.

image description

edit flag offensive delete link more
0

answered 2017-10-11 07:25:50 +0200

updated 2017-10-12 07:54:44 +0200

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

image description

image description

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

15076581288654682.ods

image description

image description

edit flag offensive delete link more

Comments

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

JG101 gravatar imageJG101 ( 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

JG101 gravatar imageJG101 ( 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.

charlie.it gravatar imagecharlie.it ( 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

JG101 gravatar imageJG101 ( 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?

charlie.it gravatar imagecharlie.it ( 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?

JG101 gravatar imageJG101 ( 2017-10-13 18:49:14 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 61 times

Last updated: yesterday