Search
Filters
Close
Thursday, August 5, 2021 9:36:28 AM

Sheet function suggestion

6 years ago
#30 Quote
Suggest that when you use the TrueFalse option, that the cell change color. Green for True, Red if False.
0
6 years ago
#34 Quote
Thank you for the suggestion.  This functionality is available in Excel now. Home Tab-> Styles -> Conditional Formatting.  There are many ways to accomplish the results desired.

IP Tools for Excel version 3.5 also presents a solution. In the IP Address Management form you can check the box to Conditional Format T/F the column.  Write the sheet into Excel. Green fill with dark green text for TRUE, light red fill with dark red text for FALSE.
0
6 years ago
#38 Quote
Thanks for the 'Conditional Formatting' tip, it works great.
0