Link to home
Start Free TrialLog in
Avatar of Seamus2626
Seamus2626Flag for Ireland

asked on

conditional formatting within an = cell

="YTD Wins = $"&ROUND((GETPIVOTDATA("Total EBV (USD000)",$K$5,"META DATA OUTCOME STATUS","Won")/1000),0)&"M - " &  TEXT(Targets!B3,"0%") & " vs target"& " ($" &ROUND(Targets!H1,0)&"M" & ")"

Hi,

My above formula returns me my result perfectly - however

If TEXT(Targets!B3,"0%") is less than 90% i want that part of the text to be red, if between 90% and 100% amber, above 100% - green

is this possible?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Seamus2626

ASKER

Not worth using VBA for this report, thanks man!