Changing cell formatting with an IF statement

[jmoffett]

I have an area of a spreadsheet that I want to "disappear" when a particular option button is selected. I can make the text go away, but part of that area has cells that are formatted differently than the surrounding cells. I would like to change the cell background color, text color, and border setting. How would the syntax read?

Thanks.

[Cheeky Charlie]

Use:
format
conditional formatting

choose the "formula is" option and put the formula as something along the lines of:
=$cellcolumn$cellrow=<criteria for changing format>
Where the cell in question is the one whose change defines whether or not the cells should be visible

Change the format as appropriate

The alternative is to use value is and value is ="" (which I presume is the result which makes the values "disappear") this needs a relative reference (no $s) to the activecell in the selection when you apply the format.

HTH

[jmoffett]

I'm not sure I completely understand your reply, but I should point out that the cells that I would like to change cannot hold the formula that changes them. They have to have a number in them. I need to be able to write a formula that will assess the value of one cell and change the format of another cell based on that value.

[Rahul Nagar]

Hello jmoffett,

Can you please attached file for more details so i can help you

regards
rahul

[Cheeky Charlie]

Open a new workbook
Select some cells - let's try C3:F16 - after you drag the area out you should see cell C3 is white within the selection (it is the active cell) it should also say C3 in the name box (above the 'A' of column A).
Goto:
Format
Conditional Formatting
Change the first box to "formula is"
Type this in:
=$A3="pie"
Click the format button
Select the patterns tab
Change the cell interior colour to a lovely pink hue
OK
OK

Now type 'pie' (no quotes) into A3, A6, A9

See how the format of the cells depends on the contents of another cell?

If you changed the reference to absolute for row and column, i.e. =$A$3="pie" The whole area would change format depending on the contents of A3.

If you made it entirely relative, i.e. =A3="pie" then the format would apply the pink shade to any cell whose neighbour two to the left holds "pie".

I hope by now this all makes sense.

HTH

mmm... pie

[jmoffett]

Beautiful! Thank you!