c.f

  1. Harley78

    Conditional Formatting based on date in cell

    Confused and need help. I enter todays date in AK8, then I created two C.F. Yellow if 14 days and Pink if 7 days from the AK8 date I enter. this C.F. is for Column AK13-600 the two C.F. are: Yellow Highlight equals =AND(AK13>TODAY(),AK13<=(TODAY()+14)) Pink Highlight equals...
  2. S

    Conditional Formatting question

    I have a spreadsheet with is approx. 10000 row by12 cloums wide and I am trying to colour band each alternative row for eay reading. The formula I am using, which allows filtering is; =MOD(SUBTOTAL(3,$A1:$A1),2) I can insert this in row A and using the format painter I can copy 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