Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

In cell G I have 2 conditional formatting's attached. I have this going down
for 50 cells, which means that whenever I print, I have set the print area. I
wanted to find somthing that would leave cell G blank with no borders or
anything if Cell B were Blank, Not sure if is a conditional format or a
formula, Thanks for your assistance.
-Markitos
 
You can do this in conditional formatting. Under condition 1 in the
conditional formatting window click the arrow and select formula is instead
of cell value. Use the formula =IF(B1>0.001,G1,""). (The 0.001 is just a
numeric test to make sure the cell B1 is MT) Apply the conditional
formatting as normal to cells G1:G50. this should work.
Pat
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Comparison of columns using Conditional Formatting 3
Conditional Formatting 1
conditional formatting update issue 5
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Conditional Formatting 3
Conditional format cell containing hyperlink 2
conditionally formatting 3

Back
Top