ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   dynamic colouring of fields (https://www.excelbanter.com/excel-programming/359169-dynamic-colouring-fields.html)

dylan[_2_]

dynamic colouring of fields
 
Hi,

I want to colour code my fields in a truth table, i.e red if false and
green if true.

What's the easiest way to do this?

Thanks in advance,

Dylan


Bob Phillips[_6_]

dynamic colouring of fields
 
Conditional formatting.

Select all the cells, FormatConditional Formatting, then set the conditions
and format.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dylan" wrote in message
oups.com...
Hi,

I want to colour code my fields in a truth table, i.e red if false and
green if true.

What's the easiest way to do this?

Thanks in advance,

Dylan




dylan[_2_]

dynamic colouring of fields
 
Oh yes, silly me!

thanks,
Dylan



All times are GMT +1. The time now is 12:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com