Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting help required
I am trying to format the background color of a cell based on text in that
cell. If the cell contains "EXCELLENT", I want to color the background green (works great). If the cell contains "PARTIAL", "GOOD", or "MEDIUM", I want to color it yellow. I've tried putting the following in a Cell, but it just returns a #Value error. =OR(SEARCH("MEDIUM", D4) 0, SEARCH("PARTIAL",D4)0,Search("GOOD", D4)0) When I only put one of these critiera in the OR function, it returns the proper logical value. Any ideas what I am doing wrong? Actually, I tested =SEARCH("GOOD", D4) and =Search("PARTIAL", D4) individually as the cell forumla and they each returned a #Value! result. Any ideas how to make this work? -- Email address is not valid. Please reply to newsgroup only. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formula help required | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Conditional formatting help required please | Excel Discussion (Misc queries) | |||
conditional value required on basis of column a | Excel Worksheet Functions |