View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default IF formula to conditionally format a cell

Select C29
From menu FormatConditional FormattingCondition1
Formula Is
=AND(N410,N41<=1594)

Select a color to highlight

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


"Very Basic User" wrote:

Sorry for the blank post, I hit enter to move to this box...

Here is my question. I have a spreadsheet where I want "C29" to say... If
"N41 is <= 1594 then shade C29 to red if not leave it normal. Can this be
done?
--
Thank you for your time!
John