Formula Modification Needed
 

This conditional formatting formula works when B30 has
values entered (condition is true). When B30 has no data
entered, I need a false condition, so no formatting
occurs. What would the new formula be?

=OR(B30=FinancialM17,B30<=FinancialM27)

Formula Modification Needed
 

"Phil Hageman" wrote in message
...
This conditional formatting formula works when B30 has
values entered (condition is true). When B30 has no data
entered, I need a false condition, so no formatting
occurs. What would the new formula be?

=OR(B30=FinancialM17,B30<=FinancialM27)

Hi Phil,

How about something like:

=AND(NOT(ISBLANK(B30)),OR(B30=FinancialM17,B30<=F inancialM27))

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

Thanks
 

Thanks, Rob, I took the "NOT" out and it worked as needed -
my fault for not being clearer with the discription.
Happy Holiday!
-----Original Message-----
"Phil Hageman"
wrote in message
...
This conditional formatting formula works when B30 has
values entered (condition is true). When B30 has no
data
entered, I need a false condition, so no formatting
occurs. What would the new formula be?

=OR(B30=FinancialM17,B30<=FinancialM27)

Hi Phil,

How about something like:

=AND(NOT(ISBLANK(B30)),OR
(B30=FinancialM17,B30<=FinancialM27))

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *



.

Thanks
 

Appreciate your input. I was not exactly clear with
problem definition - I thind the <"" part interfered
somehow. Anyway, thanks very much for your time.
-----Original Message-----
Phil Hageman wrote:
This conditional formatting formula works when B30 has
values entered (condition is true). When B30 has no
data
entered, I need a false condition, so no formatting
occurs. What would the new formula be?

=OR(B30=FinancialM17,B30<=FinancialM27)


=IF(AND(B30<"",OR(B30=FinancialM17,B30<=Financi alM27)))

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.

.

Formula Modification Needed
 

Phil Hageman wrote:
This conditional formatting formula works when B30 has
values entered (condition is true). When B30 has no data
entered, I need a false condition, so no formatting
occurs. What would the new formula be?

=OR(B30=FinancialM17,B30<=FinancialM27)


=IF(AND(B30<"",OR(B30=FinancialM17,B30<=Financia lM27)))

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.