Thread: excel
View Single Post
  #5   Report Post  
account via OfficeKB.com
 
Posts: n/a
Default excel

What is that symbol after B10. I do not know how to put that in Thank you

Roger Govier wrote:
Hi

Mark the range of cells to which you wish to apply data validation.
DataValidationfrom drop down choose Custom.
In the white pane type =B10<=B9*1.5
Choose Format and set Text colour or Cell Colour that you require.

Regards

Roger Govier

I am having a problem with a formula: It says to do under data, validation,
and in settings under allow choose custom then in the formula box, this is
where the problems i need a formula then determines that the value in cell
b10 is less than or equal to 150% of the value in b9. Please help i have
tried everything.


--
Message posted via http://www.officekb.com