Thread: conditional Formatting based on a value in another cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Khoshravan Khoshravan is offline
external usenet poster
  
Posts: 211
Default conditional Formatting based on a value in another cell
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
--
R. Khoshravan
Please click "Yes" if it is helpful.


"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