change font color of cell based on critera

A

amrezzat

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?
 
Top