Hi

In the Conditional Formatting dialogue, choose Formula is then set first
condition
=A1<"D" and set format to Red
Add
=A1<"J" and set format to Green
add
=A1="J" and set format to Yellow

Change cell reference from A1 to whatever is appropriate

--
Regards

Roger Govier



Rumpa Biswas wrote:
My requirement is to use 3 types of output format with 10 possible
cell (input) values.

Example of the problem -

If cell value = "A" OR "B" OR "C", backcolor = Red
If cell value = "D" OR "E" OR "F" OR "G" OR "H" OR "I", backcolor =
Green
If cell value = "J" OR "", backcolor = Yellow

I am aware of that VB programming can be done for this.
But I was thinking, if logical operators (e.g., AND, OR) can be used
within a conditional formatting, this problem can be solved very
easily. (I tried by myself, but could work it out.)

If anybody is aware of this, please let me know.