Conditional formatting with formula. Help please

ClarkTD

New member
Joined
Jun 12, 2017
Messages
3
Reaction score
0
Points
0
So I haven't been working with excel formulas very long so this may be super easy and I'm just overthinking it or it may be more difficult than I realise. But either way let me fill you in on what I want to do and see if someone can point me in the right direction. So I have a table with student names and documents missing, signatures missing, to be corrected and corrections made to their enrolment packs. What I want is when all 4 columns have "N/A" or "" (blank) for the row the student is on to format to a different outline type, font, and colour. And only when all 4 columns have one of those options. If they have anything else they stay their regular formatting. Sorry if this is somewhere else on the forum and i did do a couple different searches and didn't find what I was looking for .
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Select the range of cells to affect...

Assuming the first row of possible N/A or Blanks is B2:E2, then

Go to Home|Conditional Formatting, New Rule
Select "use a formula to determine which cells to format"
Enter formula

=AND(OR($B2="N/A",$B2=""),OR($C2="N/A",$C2=""),OR($D2="N/A",$D2=""),OR($E2="N/A",$E2=""))


Click Format and format as desired.
 

ClarkTD

New member
Joined
Jun 12, 2017
Messages
3
Reaction score
0
Points
0
Ahh fantastic. I haven't worked too much with AND & OR functions so that's probably why I couldn't figure it out. I'll give this a try when I get home and thanks for the quick response
 

ClarkTD

New member
Joined
Jun 12, 2017
Messages
3
Reaction score
0
Points
0
Just tested it. it works perfectly. thank you for your help.
 
Top