Thread: conditional Formatting based on a value in another cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JBeaucaire[_90_] JBeaucaire[_90_] is offline
external usenet poster
  
Posts: 222
Default conditional Formatting based on a value in another cell
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

Reply With QuoteReply With Quote