![]() |
Conditional cell highlighting
If column C has an n in it I would need any row within Column C with the n to
highlight yellow. The columns in the row that would need to highlight yellow are A through and including CB. |
Conditional cell highlighting
Click on A1 and:
Format Conditional Formatting... FormulaIs =$C1="n" and pick a highlight color. Then copy A1 and paste/special formats form A1 thru CB1 Do something similar to the rows below. -- Gary''s Student - gsnu200840 "judy" wrote: If column C has an n in it I would need any row within Column C with the n to highlight yellow. The columns in the row that would need to highlight yellow are A through and including CB. |
All times are GMT +1. The time now is 04:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com