Conditional Format
How can I edit the conditional format so null (when the cell contains
nothing) values have no shading in my spreadsheet? For example, I selected column E and applied conditional formating in order to highlight all faculty hired before 1985, however, I have null values and the conditional format appears. |
Conditional Format
Select Cell E1, then click on the Column Header of Column E
Format, Conditional Formatting, Select FormulaIS (from drow-down) in the box paste in: =AND(E10,E1<1985) Select pattern desired.. OK, (out) HTH "Isa" wrote: How can I edit the conditional format so null (when the cell contains nothing) values have no shading in my spreadsheet? For example, I selected column E and applied conditional formating in order to highlight all faculty hired before 1985, however, I have null values and the conditional format appears. |
Conditional Format
It worked great! Thank you, Jim May
"Jim May" wrote: Select Cell E1, then click on the Column Header of Column E Format, Conditional Formatting, Select FormulaIS (from drow-down) in the box paste in: =AND(E10,E1<1985) Select pattern desired.. OK, (out) HTH "Isa" wrote: How can I edit the conditional format so null (when the cell contains nothing) values have no shading in my spreadsheet? For example, I selected column E and applied conditional formating in order to highlight all faculty hired before 1985, however, I have null values and the conditional format appears. |
All times are GMT +1. The time now is 10:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com