Jump to content
  • 0

Worksheet Conditional Formating Like Excel


mike mcneil

Question

I would like to format cell colors or patterns base on certain conditions being met. For example, if I were to query the floor area of a space or window/wall area ratio, I would like for the worksheet to change the color of the cell if it is over or under a limit that I would set. This is rather easy to set up in excel and it would be a great tool to have in the Worksheets. It would be able to provide quick graphic feed back of certain information.

Thanks

Link to comment

3 answers to this question

Recommended Posts

  • 0

this is from 2009!!??

+1

This would be really helpful for multi-type housing, like housing developments. Where you can color cells/sub-cells based on certain criteria (house type, floor area > x, coverage percentage < x, etc)..

Need this like yesterday.. Hopefully this has been considered after 4 years?

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...