Hello,
My problem is simple yet I can't use this style function as it requires an empty cell.
I'd like to red color begining balance number if it doesn't match the ending balance from one line below (see attachent).
So if B2<>C3 then make B2 font red. Then I need to copy that to all B column cells.
If I use conditional formating and copy down below then all values change to B2 value.
What's the solution?
[Solved] Text color conditional format or STYLE()
[Solved] Text color conditional format or STYLE()
- Attachments
-
- balance check.ods
- (13.62 KiB) Downloaded 42 times
Last edited by MrProgrammer on Sat Oct 15, 2022 5:49 pm, edited 2 times in total.
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
OpenOffice 4.1.6 on Windows10
Re: Text color conditional format or STYLE()
In the attached file, I set up a conditional format in column B. I originally set it up in B2 and the used Copy and Paste Special to paste just the format to the rest of column B. Does this meet your need?
- Attachments
-
- balance check_fjcc.ods
- (12.85 KiB) Downloaded 50 times
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.