View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Make row white unless the value of a certain cell is 0

You can modify the formula itself to return blanks....

OR

(using conditional formatting)
1. Select the cell/Range
2. From menu FormatConditional Formatting
3. For Condition1Select 'Cell Value Is' and enter 0
4. Click Format ButtonFontColor select 'White'

If this post helps click Yes
---------------
Jacob Skaria


"Josh" wrote:

I have a massive list of formulas that arent in use untill the data is typed
into certain boxes below them, I have a cell in each row with a value of '0'
(untill edited) so what im asking is for the writing in that row to be white
then when the value is changed to 0 it turns black, is this possible?