Thread: how do i change cell text colour based on value in other cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default how do i change cell text colour based on value in other cell
Check out the below link regarding conditional formatting based on another
cell.

http://www.contextures.com/xlCondFormat02.html

If this post helps click Yes
---------------
Jacob Skaria


"Oscarrot" wrote:

i would like the text in a cell(s) to change colour when the data in another
cell is "0 or blank" and to another colour when the value is actually a
number.


Reply With QuoteReply With Quote