conditional formatting

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,489
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.

Item#of daysEvent
Item13current
Item23xmas
Item35hallween
Item410others

<colgroup><col><col><col></colgroup><tbody>
</tbody>
 

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
16,645
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
 

Forum statistics

Threads
1,078,226
Messages
5,338,958
Members
399,272
Latest member
jakepenner

Some videos you may like

This Week's Hot Topics

Top