LinkBack URL
About LinkBacks
Hi everyone,
For my office, I'm putting together a spreadsheet that will track different projects. The spreadsheet will be created by me, but shared and updated by many co-workers, many of whom are not very technically savvy. I'm trying to use Custom Formatting rules to make the spreadsheet easy to read at a glance. Here's an example of what it looks like thus far:
Pict1.jpg
You'll note that there are three types of data here:
- Tagged Data: Data which begins with some easily-searchable tag, e.g. "ABC_" "XZY_"
- Untagged Data: Data with no tag, e.g. "TOM", "HARRY", etc
- NO DATA: An empty cell
A few quick notes about tags:
- Tags may not be four characters, but will always end in a '_' character.
- In fact, I can assume that the '_' character will only appear in a tag.
- So, if a cell contains the '_' character, every character to the left of the '_' is part of the tag.
I'd love it if the three types of data could be automatically highlighted via Conditional Formatting, ultimately looking something like this:
Pict2.jpg
Here, I've already created highlighting rules for the Tagged Data, that was easy enough. But ultimately for each cell, I want the spreadsheet to automatically do the following:
If Cell is Empty:
....Apply Conditional Formatting Rule: Dark
If Cell is not Empty:
....If Cell Data has a Tag:
........Apply the suitable Formatting Rule (defined earlier?)
....If Cell Data has no Detectable Tag:
........Apply a default Formatting Rule (BLUE, dark font, whatever)
Is there a way to do this? Thank you!
Register To Reply
Bookmarks