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 red
when the fifth and sixth column is not blank



how can i do that in excel?


--
amrezzat
------------------------------------------------------------------------
amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766
View this thread: http://www.excelforum.com/showthread...hreadid=486660

change font color of cell based on critera
 

formatconditional formatpretty easy
or
use Ron's add in to google search for conditional format
http://www.rondebruin.nl/


--
Don Guillett
SalesAid Software

"amrezzat" wrote in
message ...

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 red
when the fifth and sixth column is not blank



how can i do that in excel?


--
amrezzat
------------------------------------------------------------------------
amrezzat's Profile:
http://www.excelforum.com/member.php...o&userid=28766
View this thread: http://www.excelforum.com/showthread...hreadid=486660