Link to home
Start Free TrialLog in
Avatar of alam747
alam747

asked on

conditional formatting of an excel cell

Hi,

I have excel worksheet and cell value change as "Delayed", "On Time" , I want to set conditional formatting the cell while the contain the string "Delayed" the cell pattern will be red and while its contain "On Time" the cell pattern will be green color.
Please advice how to set the formula to do that.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of timmyt851
timmyt851

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 alam747
alam747

ASKER

Hi timmy851,

I am using office 2003 and I did as you mentioned but its not working, nothing change.

Please let me know why its not working and how to fix it.

Thanks
Avatar of alam747

ASKER

Hi timmy851,

Its my mistake, there was space before the string thats why it was not working.

Thanks
Avatar of alam747

ASKER

Thanks a lot.