Hi

I am wondering if it is possible to change the number format of a column of values depending on a cell that says true or false.

I would like to be able to specify it like a conditional fromat.

I know you can do something in custom number format but as far as I know this will only evaluate the condition on the current cell value.

Any help would be most appreciated.