How to Highlight a Column Based on Specific Text in Another

[u.s.s_demon]

Hello all! I am fairly new to LibreOffice Calc. I have been using Google Sheets for the most part of my job at work to access .xlsx files or .csv files. I was wondering if there was a way to highlight prices in a column by searching for specific text in another. Is that even possible?

I have uploaded an image of the sheet I am working with to help.

Thank you for any suggestions, advice, or knowledge!

[karolus]

Select the target-range ( eg. D1:D1000 ) goto →→Format→→Conditional Format →→Condition:

Formula  … $A1="Closeout"
your_Style_name

[u.s.s_demon]

That unfortunately did not work for me.

Unless I did something wrong…

[karolus]

yeah…looks like you should write

$H1="Closeout"
instead …"closeout"

[u.s.s_demon]

I tried that and it still doesn’t highlight… Thank you for the help though! I really appreciate it.

[karolus]

So please attach to your original Question a new calc-file with ~30 copy and pasted rows from your File

[karolus]

Sorry, if your Target-Column is M like in your Screenshot, and no Column is hidden in between? … then you need the formula:

$J1="Closeout"

[u.s.s_demon]

I’ll let you take a crack at the file lol

30 from Original File.ods (25.9 KB)

I hope this file form works

[u.s.s_demon]

This is strange as it shows up on the file I attached here, but not on my original file.

[karolus]

It seems you need to remove first the already existing CF-rules for Column M

[u.s.s_demon]

Sorry about that!

30 from Original File 2.ods (24.9 KB)

I removed the CF rules for both columns.

[karolus]

works here with:

[u.s.s_demon]

For some reason, it doesn’t do anything when I put that into the CF rules. I guess my computer just doesn’t like me.