ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Conditional cell highlighting (https://www.excelbanter.com/excel-worksheet-functions/225371-conditional-cell-highlighting.html)

Judy

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.



Gary''s Student

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