View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jman Jman is offline
external usenet poster
 
Posts: 110
Default Conditional Formating Formula?



"FSt1" wrote:

hi
may need more detail but.....
formual is.....=IF(J2="",1,0).......format = pukey green. (choose your own.)

post back if that don't work....with more detail.


This worked perfectly.. Thanks.

Regards
FSt1

"Jman" wrote:

I need a formula in conditional formating.
I am CF'ing column M.

If column J contains blank cells.... format .