Conditional Formatting Formula for KPI to complete by due date

Hi

I need some help with conditional formatting.

I am tracking performance for the month based on the target. ( Column C )

I need the conditional formatting to state that if for example column H4 is less that 50 % before the 15th of each month then change colour to Red. If is between 50% to 83% then highlight in yellow. If greater that 83% ( Target - Column C4 ) then highlight in green.

This formula method must be applied to all KPI listed in Column C based on the targets raised. Please help

one easy solution to conditional formating with 3 colors is to use icons.

if greater than (target)than green
if lower than 50 than red
else yellow

but i'm not sure what you mean about the date. Are you saying that if you look at the file on the 14th of any given month then there shouldn't be any conditional formating visible?

if so, create a formating rule based on a formula like AND(day(today())>=15;H4<50%)

Don't open duplicate threads. Attach a workbook showing the problems with the approach suggested here.

Gauteng is part of your location, not an MS Office version - please update your profile.

No, you need to provide an attachment that shows the formula suggested above not working. You need to help us to help you.

I presume you applied the rule to the full range?

This rule is incorrect:

=AND($H$4<50)

It should be this:

=AND($H$4<0.5)

See the instructions at the top of the page - just add a new post with the updated workbook attached below this one. We can’t hell until you do.

As applied to cell J4 the rules need to be in order:
Red: =H4<0.5
Yellow: =H4<0.82
Green: H4>=0.82
As gaosiyou states, I am not sure what you mean about the date as none are shown on the file attached to post #1.
Let us know if you have any questions.

Guessing that C2 is on the Weekly Input (Forecast) sheet and that the target is in cell C4 on the KPI''s trendsdashboard sheet, try the following:
For Red: =C2<='KPI''s trendsdashboard '!$C$4*100
For Green: =C2>'KPI''s trendsdashboard '!$C$4*100
If this isn't what you need then please upload another copy of the file and manually highlight cell C2 the way you want it so that we have something on which to base the results of our proposed conditional formatting rules.
Let us know if you have any questions.