I have a cell counting dates from 2022 09 01
I am trying to higlight this single cel, if the cell value is 20 or 18 or 60
To clarafy
If the cell value is 20 = Higlight cell
If the cell value is 18 = Higlight cell
If the cell value is 60 = Higlight cell
Conditional formating works for one number but how can i add many numbers?
or is there a better way to do this
Thank You
[Solved] Highlight a single cell, if the value is equal to list of numbers
[Solved] Highlight a single cell, if the value is equal to list of numbers
Last edited by Hagar Delest on Mon Sep 19, 2022 9:38 pm, edited 2 times in total.
Reason: Tagged [Solved].
Reason: Tagged [Solved].
Open Office 4.1.11 on macOS Catalina
Re: Higlight a single cel, if the cell value is equil to list of numbers
Set the leftmost box of the conditional formatting to Formula Is and then set the formula to
Code: Select all
OR(A1=18;A1=20;A1=60)
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.
Re: Higlight a single cel, if the cell value is equil to list of numbers
FJCC, Thank you for showing me how to fix to my problemFJCC wrote: ↑Mon Sep 19, 2022 3:22 pm Set the leftmost box of the conditional formatting to Formula Is and then set the formula toCode: Select all
OR(A1=18;A1=20;A1=60)
you saved me lots of research time
Thank you
Open Office 4.1.11 on macOS Catalina