View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
KRK KRK is offline
external usenet poster
 
Posts: 91
Default conditional formatting

Hello,

I have a spreadsheet with several rows of data.

The first cell of each row contains a logical formula which equates to
'TRUE' or 'FALSE'.

I want to hide the rest of the cells in the row if the first is FALSE.

I have been trying to use conditional formatting to do this, setting the
text colour to white so that the cell contents become 'invisible'

I cannot seem to get it to work, I think I'm getting the conditional
statement wrong in the conditional formatting box, but am not sure ?

Any advice or pointers please ?

Thanks

KK