any value

  1. G

    Conditional Formatting

    Hi! Is there a way to do a conditional formatting so that if X cell has ANY value in it? As in, just NOT blank? Cell G8 I want to turn red if cell L3 has anything at all in it. It's so simple, and I'm sure that there's something like, "L3="#value"" or some trick to do that. I just have...
  2. T

    Data validation: Value "b" in another cell allows any value

    If value of cell A1 is "a", then I want data validation (list of choices) for cell B1. If value of cell A1 is "b", then any value can be entered into cell B1. Data validation doesn't automatically support this. How to do this?
  3. L

    COUNTIFS count if a cell has a value

    Ok so I can get the COUNIFS function to count what i want it to count, but I'm trying to make the cell either leave it blank if the cell right next to it is null, or have it post the counted number if there is ANY value in the cell right next to it.. This is what I have now. I'm not sure if this...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top