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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conditional formatting
Suppose the range goes from A1 through F1, then select this range ensuring A1
is the active cell. Then enter the following formula in the CF: =$A$1=FALSE Now, format the font color to white. If A1 is false (first cell in the row), then all other cells will be white. -- Robert Author of RibbonX: Customizing the Office 2007 Ribbon: LATEST INTERACTIVE TUTORIAL: http://www.msofficegurus.com/videos/...p_HT_Chart.asp FORUM: http://www.msofficegurus.com/forum/ |
Reply |
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 |