Get instant live Excel expert help to learn how to combine conditional formatting with IF statement

How to Use Conditional Formatting to Change Cell Background Color Based on Cell Value not for only 1 cell but all the cells depending upon the cell value entered. for example I have four status as 1 )open 2) Resolved 3) Overdue 4) hold. I want the cell should change color as green if resolved and red as overdue and open as brown and hold as yellow.

use conditional formatting so that if an OPPORTUNITY_STATE is "Won" then it turns the background green, "Lost" or "Abandoned" it turns red and "Open" it turns blue

I need to make a rule for conditional formatting or maybe another way to hightlight something. in B2, B3, B4 are shifts like from 6-10 am, 6-12 am, depending on that i want the Cells to be greyed out if it is outside the time. Example: B2 is 6 -10, so C2 - J2 it stays white and from to J2 - AF21 its greyed out. if B2 is 6-12, C2 - N2 is white and the rest grey. I dont want to make like 100 rules, is there any way around?

Conditional formatting where a number is higher than than in another cell... should be straightforward... BUT as that other cell is calculated to include VAT and may show a rounded up figure, I am finding sometimes that even though the value shown is the same (EG £20.25) if the ACTUAL value of the cell being checked is £20.2487, the conditional formatting is triggered incorrectly! Any ideas please?

If difference between end shift and start shift(column C and column E) is <8 hr then d3 is red. Conditional formatting will be needed.

Hello, I want to change the font color for lines that have been updated. If a new position or new step is entered, the font colour of the entire row should be changed in orange. Column E > conditional formatting > manage rules > New rule > Use a formula to determine which cells to format Formula =IF(NOT(ISBLANK($E2)),TRUE) Format = Bold orange color Applies to : =$A$2:$F$2 How to replicate it to the following rows? The formula does replicate but not the Applies to For row 3 I should get Formula =IF(NOT(ISBLANK($E3)),TRUE) Format = Bold orange color Applies to : =$A$3:$F$3 Thank you

I need a conditional formatting rule that checks first to see if A2 is empty and then formats E2 a certain way. I need this rule to be primary before others. E2 contains an IF formula which returns "Yes" or "No" if either B2, C2 or D2 are empty cells.

I need to prepare a simple sheet based on certain conditions. Functions like filters, if, ifonly,conditional formatting

I need a formula to use in conditional formatting... I need to highlight cells in Column C, if the same value is found anywhere in column A in another worksheet.

I'm trying to set-up conditional formatting for the following. I want it to change the row to yellow if there is a date in D1 A1 B1 C1 D1 red blue white 7/24/2018