conditional Formatting based on a value in another cell

B

Brian

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
[email protected]
 
J

JBeaucaire

Use conditional formatting:

Condition1: Formula Is: =R30>0
(format green)

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

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

Khoshravan

Select the entire range of cells you want to apply this CF. Go to Format|
Conditional Formatting. You can define your three conditions here. If you
encounter any problem, post here
 
B

Brian

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

Brian
 
K

Khoshravan

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.
 
B

Brian

I do apologize, ok I just got the final instructions.

ok, if Q30 is <Q29 then red data bar
if Q30 is >Q29 then green data bar
If Q30 = Q29 then orange data bar.

The Percent values are in the Q Columns,

Now in the R colum, now I have merged R29 & R30 into one cell, so in the
merged cell if Q29>Q30 then green up arrow ( under icon sets)
if Q29<Q30 then Red Down aarow

Finally, how do I apply these formats from Q28 back up to Q5 the same with
the merged cells in the R column.

thank you
Brian
[email protected]
 
Top