asked on

Excel 2007 Flag

I am needing help with creating a flag or conditional formatting.

I have column (F) titled TYPE, I have column (R) with R1 titled SCORE and I have column (S) with S1 titled IPP FLAG.

I need for something (maybe a red X ) to populate in the IPP FLAG column if the TYPE is IPP and data in the SCORE column is below 4.50

ASKER CERTIFIED SOLUTION

DOSLover

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Chris Miller

ASKER

Perfect, thanks.

Chris Miller

ASKER

Well...I spoke to soon. It works if I manually type in the SCORE but I failed to menchion this because I didnt think it would matter but the excel sheet gets some information from another tab. So, when I select an employee name from column B it populates the R column (SCORE).

Here is what is in R2 =IF(ISNA(VLOOKUP(B7,tblTechnicians!A:AD,29,FALSE)),0,VLOOKUP(B7,tblTechnicians!A:AD,29,FALSE))

The flag column is not responding to the SCORE column being auto populated.

Chris Miller

ASKER

ok....I changed arrow direction and its working.

=AND((F2="IPP"),(R2 > 4.5))

changed from < to this >

DOSLover

Are you sure it is working? The condition (r2 > 4.5) is not waht you need, right?

Please try this, replacing the formula in Cell S2 that I have earlier. And then copying formula to other cells. This refers to value of Cell R2:
=AND((F2="IPP"),(VALUE(R2) < 4.5))

Chris Miller

ASKER

correct, greater than 4.50 is NOT what I need. I want it to show red if the score is below 4.50.

It looks like the new formula is working. I will try a few more samples.

Thanks.