Hello, i'm trying to use the conditional formatting icon set check mark, and X to format column A based based on what is in Column B
Column A is STATUS
Column B is formatted as TIME
I would like to use conditional formatting in Column A (status).
If there is a time entered in Column B then a...
I am trying to modify/create a Bank Deposit worksheet for an office with numerous working parts to it. I created a deposit sheet several years ago with three working pages. The first page is for entering check numbers and check amounts. Second page is for "double check" for checking the dollar...
This seems simple but i'm stumped.
I have a change order document with a summary page on the first sheet and subsequent change order sheets.
I've linked the sheets so that data entered in the summary sheets appears in the change order sheets and vice versa.
On the summary sheet, I want the date...
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.