conditional fomatting

  1. B

    Conditional Formatting Problem

    I have tried using conditional formating and it does not seem to do the trick. What Im needing is Example: If A1 contains the same data is A2 then fill the cells yellow. In conditional formatting when i do this the cells turn yellow, I need them to wait till there is data in them before they...
  2. SimonHughes

    Conditional Format Question

    I have a sata set and want to highlight the row that contains the highest percentage. I have used this formula =IF(Q7=LARGE(Q$7:Q$26,1),1,0) and it is giving me the curious result shown below where the sales value is not highlighted. Any ideas as to how I can correct this? I am using Excel...
  3. F

    Conditional Formatting Dates based on number of days that have passed

    I am trying to figure-out how to set up conditional formatting of dates in a column (e.g. Date Submitted) and have these dates, and/or cell, change color as time progresses. I have Excel 2007. For instance I have an application submitted on 11/20/2011 in a cell. I would like to have the date...
  4. M

    unlock cell on exit

    Please bear with me while I try to explain this.. I have a workbook which information is fed in through the frontpage. On running the MACRO the information is then sent to numerous other pages for working out costs, this then clears the boxes ready for the next batch of information...
  5. andrewb90

    Shading a cell range based on where the user is typing

    Can I have a range of cells (B9:G9) highlight if any cell within that range is being clicked on or typed into? I would want to apply this to rows 9:67. Thanks, Andrew

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