I'm trying to have certain cells highlight based on peoples job titles. So, if I have CEO, COO, CFO, etc. in the name manager under "_BusinessOFF" if anyone with those titles comes up I want to have a specific background color come up but when I use the formula...
Hi guys,
Id like to have the conditional formatting setup in cell G6 so that it does the following:
1. When cell G6 is below a cell value of 18 cell G6 has a green fill.
2. When cell G6 is a blank cell G6 it has no fill.
3. When cell G6 is above a cell value of 18 cell G6 has a red fill.
4...
i have a sheet with values in Column D and E
Now, they enter values in E45 and E36
Afterwards, they enter a value on D48 (They should calulate the difference of E45 and E36
The conditional formula should make the cell D56 red if they value they enter is not equal to the difference of E45 and...
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.