Conditional Formatting
I cannot understand what I'm doing wrong - I have two columns titled 'Owner First Name' and 'Owner Last Name'. There is a third titled 'Registration Type'
I have conditional formatting setup that if the cell is blank to turn it red. I added another condition that if the Registration Type is 'Partnership' to ignore and to not turn the cell red (we don't need this data for that registration type)
I have the rules setup the exact same for both columns, yet the Owner Last Name continues to show red. (ignore the blue, it's text box I put over sensitive data). Yes, the Registration Type on both those rows is set to Partnership.
This is the conditional formatting I have set so it's identical for each column, yet the Owner Last Name is still showing red.
What am I missing here?
Answers
-
It would help to see a more complete screenshot.
You could try adding a rule above your existing ones to format the cell with a white background if Registration Type is Partnership, but theoretically the way you are doing it should work so long as the criteria is being met.
____
Dan Palenchar // School of Sheets Solutions Consulting // Principal
schoolofsheets.com (Smartsheet consulting)
schoolofsheets.com/youtube (Smartsheet tutorial videos)
👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner
If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!
- 🆘 Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
- ▶️ Smartsheet Tutorial Videos: schoolofsheets.com/youtube
PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!
Help Article Resources
Categories
Check out the Formula Handbook template!