If formula to conditonally format a cell
 

--
Thank you for your time!
John

If formula to conditonally format a cell
 

There are many possibilities, but lets say you want the cell (A2) to turn red
if value is under 0.
select a2, then goto Format-Conditional Format.
Change first box to "formula is". Input
=A2<0
Click format, go to patterns tab, pick red. Hit 'ok'. Hit 'ok'. Cell is now
formatted.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Very Basic User" wrote:


--
Thank you for your time!
John