conditionally formatting cells based on other cells

[Derrick]

is it possible?
i have a cell that i want to format based on whether an adjacent cell is
blank or not.
ie

Max_Allowable must be 'hidden' when Min_Needed = 0,
Visible when Min_Needed <> 0

the problem now is that if i want to conditionally format the Max_Allowable
column, i can only compare values with "Max_Allowable", not the "Min_needed"
i'd like to compare it with

i know how to do the hidden - make the same colour as the background - part.
I just need to know if I can base the format on another cell's contents...
even using a macro if needed?

 

[JLatham]

Excel 2003 formatting:
Select the Max_Allowable cell, use Format --> Conditional Formatting
Choose Formula Is (instead of default Cell Value Is)
and enter this formula:
=$A$2=0

change the $A$2 to the address of the Min_Needed cell. Then set up the
format to set the font color the same as the background (white probably).