Formula Modification Needed

  • Thread starter Thread starter Phil Hageman
  • Start date Start date
P

Phil Hageman

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)
 
Phil Hageman said:
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)
Click to expand...

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, Rob, I took the "NOT" out and it worked as needed -
my fault for not being clearer with the discription.
Happy Holiday!
 
Phil said:
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)
Click to expand...

=IF(AND(B30<>"",OR(B30>=FinancialM17,B30<=FinancialM27)))

Regards,
 
Back
Top