The Silence Map

Asked on Super User by Jagan K, 1 year ago. No reply there for at least a week.

How to avoid particular cells which are having conditional formatting in the Spreadsheet?

I have prepared a spreadsheet with conditional formatting and following are the details. Cell=K39 is having Data Validation clause. Excel cell with Data Validation Clause when the K39 = 3, particular cell range is visible to edit the data and if the value is less than 3, this cell range would not appear. The particular cell range is not visible with K39=2 The particular cell range is visible with K39=3 However, I am having different colour coding for excel for appearance and the sheet is printing in 'Black and White' Sheet is printing in Black and White The query is, upon seeing the excel if K

This question is one of 1 report of the same problem:

How to avoid particular cells which are having conditional formatting in the Spreadsheet?

Nobody has answered it yet, here or anywhere.

Related problems

Question by Jagan K on Super User, licensed CC BY-SA. We show a short excerpt and link to the original thread as credit.