conditional formatting

[lezawang]

Hi
I have the table below. I want to use conditional formatting or any other way to highlight
the event based on condition like the following:

If the event takes less than 14 days, then I highlight "Current" in the 3rd column. but not to highlight the "xmas" or any other events which have number of days less than 14 as well, only current.

Is that possible? Thank you very much.

[TABLE="class: grid, width: 218"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Item[/TD]
[TD]#of days[/TD]
[TD]Event[/TD]
[/TR]
[TR]
[TD]Item1[/TD]
[TD="align: right"]3[/TD]
[TD]current[/TD]
[/TR]
[TR]
[TD]Item2[/TD]
[TD="align: right"]3[/TD]
[TD]xmas[/TD]
[/TR]
[TR]
[TD]Item3[/TD]
[TD="align: right"]5[/TD]
[TD]hallween[/TD]
[/TR]
[TR]
[TD]Item4[/TD]
[TD="align: right"]10[/TD]
[TD]others[/TD]
[/TR]
</tbody>[/TABLE]

 

[JoeMo]

Assuming your table is in columns A:C with the headers in row 1:
1. Select all the cells in col C you want to apply the CF to.
2. Home>Conditional Formatting>New rule> use a formula
3. Formula is: =AND($B2<14,$C2="current")
4. Select the format you want
5.Click OK

 

[lezawang]

That is really great. Thank you so so much.

 

[JoeMo]

That is really great. Thank you so so much.

You are welcome - thanks for the reply.