conditional format formula

  1. ChrisMac1

    Conditional Format

    Hi there, I have a workbook called Complete_Asset_Fields.xlsx which is made up of two sheets, CompleteAssetFields and Sheet1. I need to highlight all the values in column BC on the sheet CompleteAssetFields, that also appear in column A on Sheet1. Can you help me with the formula to use in...
  2. tycasey17

    Conditional Formatting Based on Name Manager

    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...
  3. C

    Conditional Formatting based on 4 cell factors

    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...
    • camerong
    • Thread
    • conditional format formula formatting a cell urgent helped needed!
    • Replies: 5
    • Forum: Excel Questions
  4. E

    Conditional formula based on difference of two other cells

    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'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