Need help in Conditional Formatting for the entire row

#1
Hello,

Need help with conditional formatting.

I have attached this spreadsheet where I have applied Conditional Formatting in the column, "Supplier Status". The colors change in the cell but how can I have the conditional formatting colors across the entire row?

Also how can I have white colored font when the background is red color as part of conditional formating?

Thanks!
.
 

Attachments

Elsmar Forum Sponsor

AMIT BALLAL

Super Moderator
#2
Hello,

Need help with conditional formatting.

I have attached this spreadsheet where I have applied Conditional Formatting in the column, "Supplier Status". The colors change in the cell but how can I have the conditional formatting colors across the entire row?

Also how can I have white colored font when the background is red color as part of conditional formating?

Thanks!
.
For conditional formatting across complete rows:
1. Select the complete table where you want to apply conditional formatting (where the rows are located)
2. Go to "Conditional formatting" option on home tab
3. Select "New rule"
4. Use last option from list, which is "Use a formula to determine which cells to format"
5. Formula tab will appear below "Format values where this value is true" message
6. Enter "=$H4="Preferred" formula in this formula tab
7. Now go to format option on same window
8. Select the color you want to choose for the option (In this case, it will be green- as per your selection)
9. Click "OK"
10. Repeat same process using different formulas just by replacing "Preferred" by "Non-Preferred", etc.
Eg. =$H4="Non-preferred"
And choose the color of your choice.

For changing font color of conditional formatting: (If conditional formatting is already done and you just want to change the font color)
1. Go to conditional formatting
2. Choose "manage rules" option
3. Select the rule where you want to modify the color
4. Click "Edit rule" option
5. Click on "Format" option
6. Go to font tab
7. Under color option, click on drop-down menu where default value will be "automatic". Choose color of font of your choice.

Attached herewith your excel sheet with conditional formatting applied to rows.

:2cents:
 

Attachments

Last edited:

krapow

Starting to get Involved
#4
Very good indeed. Using your advice, it took me all of 1 minute to figure out what was taking me 8 hours from yesterday to get my worksheet correct. Thanks Again!!!
 
Thread starter Similar threads Forum Replies Date
M Attempting to Poke Yoke a wire crimping process...need help Design and Development of Products and Processes 3
C I need your help to find the action plan for these quality objectives Misc. Quality Assurance and Business Systems Related Topics 23
R Need help on calibration result analysis Measurement Uncertainty (MU) 17
G Need Help with Run @ Rate for Medical Devices ISO 13485:2016 - Medical Device Quality Management Systems 0
F Need help in IMS management review Management Review Meetings and related Processes 3
S I need help in corrective action plan Nonconformance and Corrective Action 15
D Weird spec sheet - need help Measurement Uncertainty (MU) 3
K Need Help With Auditing Suppliers Against ISO 9001 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 50
R Lead auditor scenario (Need help) is this non conforming to ISO13485 Manufacturing and Related Processes 2
U Need Help With API Q2 Quality Manual Oil and Gas Industry Standards and Regulations 8
D Need some Help on 8D fault tree analysis Problem Solving, Root Cause Fault and Failure Analysis 6
K Screen printing ink and machine selection_ Need help Manufacturing and Related Processes 6
J Need Help with FPY Data in Assembly Process Manufacturing and Related Processes 7
S Need help on "Country of Origin" Medical Device and FDA Regulations and Standards News 0
M Need Help With Information Security Asset Risk Register IEC 27001 - Information Security Management Systems (ISMS) 2
C ISO/ IEC 17021 Resource requirement (need help) Document Control Systems, Procedures, Forms and Templates 5
SocalSurfer AS9100 new certificate, but need QMS software, help Quality Assurance and Compliance Software Tools and Solutions 2
S Need help with analysing a survey on minitab Using Minitab Software 1
K A proposal for the model Quality Management - I need help for the project ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
R Probability - Need a help to solve the below question Statistical Analysis Tools, Techniques and SPC 5
8 Need Help - Runout - Function Gage Inspection, Prints (Drawings), Testing, Sampling and Related Topics 7
S New to FAIR, need help in filling it out AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 8
R Pls help --- Need expert advice on Video Measurement Measurement Uncertainty (MU) 0
Ajit Basrur Need help to understand HIPAA requirements ISO 13485:2016 - Medical Device Quality Management Systems 17
Z I need help with getting a CFS in China Manufacturing and Related Processes 2
S Need help wrapping my head around confidence vs beta error Statistical Analysis Tools, Techniques and SPC 2
P Received a minor for not having good measureables/goals. Need help with KPIs. IATF 16949 - Automotive Quality Systems Standard 52
A Failed the AS9120B Exam Twice.....Need Help AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 11
H Need help on Quality Improvement Plan (QIP) Quality Tools, Improvement and Analysis 5
S Help: Need Control Self Assessment Questionnaire for HR Departmental Functions Process Audits and Layered Process Audits 0
M Need help in Calibration of Directional Coupler General Measurement Device and Calibration Topics 2
L Need HELP with Internal Audit Program ISO 13485.2003 Quality Management System (QMS) Manuals 3
J Supporting Processes - Internal Audits - Need help settling a debate IATF 16949 - Automotive Quality Systems Standard 4
A Cpk Formula seems off, need help!? Capability, Accuracy and Stability - Processes, Machines, etc. 11
A Need Help With AEA Auditor Related Situational Questions AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 1
E Transformer Overload Test - Need help IEC 60601 - Medical Electrical Equipment Safety Standards Series 3
C I Need Help with Drafting Conventions!!! Design and Development of Products and Processes 4
M Need help on QMS Development in an AS9100C certified organization AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 10
R Need Help on Analysis: How to know potential causality model from historical data Problem Solving, Root Cause Fault and Failure Analysis 5
B Need help tracking training for my business Quality Assurance and Compliance Software Tools and Solutions 3
B Need help with a Control Plan for Encapsulation Mold / Trimming / Forming Tooling FMEA and Control Plans 9
S I need help from all of you bros Oil and Gas Industry Standards and Regulations 1
LRE67 Need help identifying this "thing" Coffee Break and Water Cooler Discussions 9
G Need help on Device Description in the Acceptance Checklist for Traditional 510(k) Other US Medical Device Regulations 2
K Need help finding a book on Documentation Book, Video, Blog and Web Site Reviews and Recommendations 8
J Need help/advice on video editing software etc..... Coffee Break and Water Cooler Discussions 8
L Need Help with Case Study Questions Manufacturing and Related Processes 16
W Help explaining the need for the Process Approach AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 4
Ron Rompen Unusual problem with Excel - Need some help Excel .xls Spreadsheet Templates and Tools 7
S Need help on new TS 16949 Rules IATF 16949 - Automotive Quality Systems Standard 5

Similar threads

Top Bottom