When I apply a Conditional Format to a cell containing a specific word, the color I designate for the cell does not show on the spreadsheet.
Can someone give me guidance on the proper steps to take?
Thanks . . .
Why do you need the Tags “common” and “text”.
I suspect your question is about Calc, or?
Please retag.
I figured it out thru trial and error! It’s very simple and I was surprised someone didn’t respond with the process as I’m about to present.
- Click on the cells, columns or specific range you want to apply “Conditional Formatting” to.
- Click on the Conditional Format drop down menu
- Click on “CONDITION”
- Where it opens make sure Condition 1 shows “Cell Value Is”!
- Click the 1st drop down menu and click on “CONTAINS”.
- In the blank to the right enter the specific word, number, date, etc you want to apply the condition to.
- Tab to the “Apply Style” drop down menu, hit the arrow and select “NEW STYLE”
- It will open to the Cell Style Page, and the Organizer Tab. In the Name Box, give the Condition a name.
- Select the BACKGROUND Tab, then the COLOR Tab, then select the COLOR you want for the specific Condition.
- Hit OK and you are DONE!