Need help in Conditional Formatting for the entire row

Ajit Basrur

Staff member
Admin
#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

Trusted Information Resource
#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
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
M Need help with Network Analyzers and which DUT can be Calibrated with it Calibration and Metrology Software and Hardware 2
R Need help on defining scope for Design Verification File for Class III IVD 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 8
J Help I need your opinion on a News Letter Misc. Quality Assurance and Business Systems Related Topics 15
N Need Help Preparing for Medical Device Quality Engineer Interview Career and Occupation Discussions 2
B Need help on an application we are working on Coffee Break and Water Cooler Discussions 4
S Need help with Project Charter for my Six Sigma Green Belt Project Six Sigma 1
Q Need help on MSA study on a torque analyzer Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
B Need help in adding second location to FDA Registration Other US Medical Device Regulations 4
T A survey on problems during ISMS implementation - need help IEC 27001 - Information Security Management Systems (ISMS) 2

Similar threads

Top Bottom