Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |