Hi,
Can someone help me with the below? I have a license for Office 2016. I am trying to create a spreadsheet which does the following.
1) Make G and H column = A and B column (So, whatever is typed in A and B column appears automatically in G and H column)
2) If I column is not the same as C column - then colour the cell K green. If not highlight the cell red and display text 'missing part' in column K.
Thank you for any tips you may have.
Excel Hlep.PNG
in G1
=IF(A1<>0,A1,"")
in H1
=IF(B1<>0,B1,"")
in K1
=IF(I1<>C1,"Missing Part","")
Select K1
Conditional Formatting
New Rule
Use a formula to determine...
=(I1=C1)
format as green
=(I1<>C1)
format as red
Use Format painter (paintbrush icon) to copy to other cells
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks