How to Highlight Data

[RavensFtw]

Hello!
I have a question, can anyone give me a step by step on how to highlight data?

Let me explain what that means

Lets say anything above 100 is unusual- I would like excel to Highlight that Box in a red Color.

Can anyone explain to me how to do that?

Also, I would like to do it for two different data sets, so 50= Likely= Yellow, 100= Normal= Orange, 200= Unlikely= Red

[pjwhitfield]

Conditional Formatting is your friend here. Highlight the cells you want then go to Conditional Formatting on your Home Menu, set up rules matching your requirements, make sure you do them in the sensible order ie > 199 first, then between 100 and 199 and lower than 100 3rd.

[FDibbins]

To add to what pjw said...
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter your formula.

The formula only needs to evaluate to TRUE or FALSE, so you can just use =A1>199.....you dont need to say =if(A1>199,TRUE,FALSE)

[RavensFtw]

Thank you very much

[FDibbins]

Glad to help