View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
amrezzat[_9_] amrezzat[_9_] is offline
external usenet poster
 
Posts: 1
Default change font color of cell based on critera


heloo
suppose that i have 6 coloumns as follw

1 2 3 4 5 6

i want to change the font color of the third and forth column to re
when the fifth and sixth column is not blank



how can i do that in excel

--
amrezza
-----------------------------------------------------------------------
amrezzat's Profile: http://www.excelforum.com/member.php...fo&userid=2876
View this thread: http://www.excelforum.com/showthread.php?threadid=48665