You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

User profile for user: Bear34_1
Bear34_1 Author
User level: Level 1
12 points

Conditional Highlight

I’m using a Conditional Highlight technique I found on this forum to highlight 3 columns.  Basically, if column B (Qty) has an entry and columns C, E or G are blank, those columns are highlighted until an entry is made in each column.


Currently, I’m using 3 helper columns to achieve the conditional highlighting for each of the column.


I’m curious if it’s possible to use a single helper column to perform the conditional highlighting for the 3 columns?


I’ve played around with various combinations of AND and OR statements, but I don’t get the desired results.


I need each cell to retain its conditional highlighting until an entry is made for that particular cell and not impact (change) the other blank cells.


Thank you



Posted on Jun 11, 2022 12:09 PM

Reply
Question marked as Top-ranking reply
User profile for user: Ralf-F
Ralf-F
User level: Level 4
2,711 points

Posted on Jun 11, 2022 2:01 PM

You can try this


As long as cell B2 is empty none of the other cells will have a highlight.

Formula for cell F2: IF(B2="","###","") You can use every string to replace ###.


Create this highlight rule in cell C2, column F must be fixed. Copy it to D2 and E2 (copy & paste)

Then drag cells C2 to F2 down using the yellow dot.


Based on your region the , or the ; will be used to separate the different sections of a formula.


Hope this will solve your question, please let me know if something in unclear.


Ralf

View in context

Similar questions

2 replies
Question marked as Top-ranking reply
User profile for user: Ralf-F
Ralf-F
User level: Level 4
2,711 points

Jun 11, 2022 2:01 PM in response to Bear34_1

You can try this


As long as cell B2 is empty none of the other cells will have a highlight.

Formula for cell F2: IF(B2="","###","") You can use every string to replace ###.


Create this highlight rule in cell C2, column F must be fixed. Copy it to D2 and E2 (copy & paste)

Then drag cells C2 to F2 down using the yellow dot.


Based on your region the , or the ; will be used to separate the different sections of a formula.


Hope this will solve your question, please let me know if something in unclear.


Ralf

Reply

Conditional Highlight

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.
Learn more Sign up