Forum Discussion
Shade a cell but not print that color?
I would try changing the conditional formatting to Rule Type “Format only cells that contain” then change the first drop down under Rule Description from “cell value” to “blanks”. That way any data entered would trigger the highlighted cell to turn white once filled. Hope this helps!
Amber-Lee Dood... This has been sooo helpful. Thank you. Now, considering I am using this for a field form, there are fields that are shaded until filled in; however, I will have many fields that do not get filled in. Is there a way to create a conditional format for fields that are not filled in (e.g., won't change the field from shaded to blank), but I still want all shading to go away upon printing/saving.
It would be acceptable if the shading did not go away when saved as an xlsm extension, but when later saved to pdf. Is that possible?
So happy for solutions. Thanks.
Pledesma012 You could use Conditional Formatting to accomplish that.
1. click on New Rule
2. Rule Type Format only cells that contain
3. Format only cells with set to Specific Text and use N/A
4. Click on Format, Then Font Tab and set color to White
OR
1. click on New Rule
2. Rule Type Use a formula to determine which cells to format
3. Enter formula =EXACT( "NA", A1 ) or =EXACT( "N/A", A1 )
4. Click on Format, Then Font Tab and set color to White
