I want to highlight certain numbers in the list below.
Here are the numbers I care most about:
0, 15, 20, 25, 30, 40, 45, 60, 75, 80, 90
My preference would be to highlight any number not listed above in red.
Another option would be to highlight any number that IS on the list above in...
Is it possible to "conditionally format" an ActiveX combo box like you can a cell? What I am wanting to do is require a selection to be made from the combo box. I would like for the box to be red until a selection is made.
Also, which is better to use? ActiveX or Form controls? I am very green...
I am trying to do a conditional formatting formula. I have Columns M and N. Both are either Y or N values. I need a conditional formatting that will highlight both cells in the row for M and N if M=Y and N=N. Now column M can also equal N and column N can also equal Y. I just need it to only...
Hi,
I have a large dataset which should be formatted with green, yellow or red color based on the value compared to the value in another target cell. I want the negative value to be treated exactly as the positive value (negative deviation is equally bad as a positive deviation).
This is where...
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.