Conditional Formatting Issues

[Guest]

I have this formula: =IF(B11<>" ",AN11<=0, AS11>0) which turn the background color of cell AN11 RED to alert the data entry person that there needs to be a value greater than 0 entered if cell AS11 (AN11 cannot be left blank) has any value greater than 0.

Now, I need the background color of cell AN11 remain in it's native state if there is no value in cell AS11.

Is this possible, if it is, how.

Again, change the background color of cell AN11 to RED if the is a value in AS11 greater than 0, thus, forcing the data entry person to enter a value greater than 0 into cell AN11 not leaving it blank. However, if the cell AS11 is blank, leave cell AN11 in it's native background color = Yellow

Thanks for the assistance.......

 

[{*BoB*} OZZIE]

Jay - I don't think that the formula is the "vehicle" that
is changing the cell color - but rather conditional
formating (under format/conditional format). Once your
formula post the results in the cell, the conditional
formating kicks in.

-----Original Message-----
I have this formula: =IF(B11<>" ",AN11<=0, AS11>0) which

turn the background color of cell AN11 RED to alert the
data entry person that there needs to be a value greater
than 0 entered if cell AS11 (AN11 cannot be left blank)
has any value greater than 0.

Now, I need the background color of cell AN11 remain in

it's native state if there is no value in cell AS11.

Is this possible, if it is, how.

Again, change the background color of cell AN11 to RED if

the is a value in AS11 greater than 0, thus, forcing the
data entry person to enter a value greater than 0 into
cell AN11 not leaving it blank. However, if the cell AS11
is blank, leave cell AN11 in it's native background color
= Yellow