conditional formatting

K

KRK

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
 
R

Robert Martim, Excel

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top