Forum Discussion
Conditional Formatting
Your request itself brings forth a number of questions that need to be addressed.
Perhaps foremost, since you're developing this for "external users to follow and understand" would it be possible for you to post a copy of what you have developed so far? That would help your would-be helpers "to follow and understand." Post a copy, if it's possible, on OneDrive or GoogleDrive with a link pasted here that grants access.
That said--and please post if at all possible--the plethora of colors you are describing could actually make things more confusing, the exact opposite of your goal. A clear/clean design in terms of data entry points (Input) and separate area for results (Output) --in different parts of the workbook, quite possibly separate tabs--might help more than differentiating by color but having Input and Output distributed randomly throughout.
It also would help if you'd describe for us the bigger picture: what is this spreadsheet all about? Who are the users? What's the context?
- Hello, Sorry for the late response. I have uploaded a test file to explain better what I want to accomplish. Thanks.
OK. I've added to your comments and created one condition formatting rule. I've added comments to the other requests that explain why I don't think conditional formatting, per se, is what you need. You'd be making things far more complicated than is necessary, for the most part. Just format them according to what formulas are in the cells already. Or their placement.
