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

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

JG101
35 ●24 ●32 ●37

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

Comments

Anyone? ..

JG101 ( 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 ( 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 ( 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 ( 2017-10-16 22:17:35 +0200 )edit

add a comment

2 Answers

Sort by » oldest newest most voted

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

charlie.it

1722 ●17 ●24 ●45 http://www.charlieopen...

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

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

15076581288654682.ods

image description

edit flag offensive delete link

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 ( 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 ( 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 ( 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 ( 2017-10-11 18:51:16 +0200 )edit

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

Yes, Ty Charlie

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

add a comment

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

m.a.riosv

25999 ●9 ●53 ●141

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

add a comment

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

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

Comments

2 Answers

Comments

Question Tools

Stats

Related questions

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

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

Comments

2 Answers

Comments

Question Tools

Stats

Related questions

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

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