Could you please explain what do you mean by: "Green arrow".
You already changed the color so they are distinctive, what would be the
function of this green arrow? Unless you want to define another condition.
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Brian" wrote:

Ok, now I've just been told to put a Green arrow and the Data bar?? can I do
both?

Brian

"JBeaucaire" wrote:

Use conditional formatting:

Condition1: Formula Is: =R300
(format green)

Add
Condition2: Formula Is: =R30<0
(format red)

Add
Condition3: Formula Is: =R30=0
(format yellow)

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Brian" wrote:

I want to put a green data bar if the value in R30 is 0 or a Red data bar if
R30 is < 0 , and finally a yellow data bar if R30 = 0.

I am calculating math test scores.

Thanks
Brian