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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi timmy851,
Its my mistake, there was space before the string thats why it was not working.
Thanks
Its my mistake, there was space before the string thats why it was not working.
Thanks
ASKER
Thanks a lot.
ASKER
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