change font color of cell based on critera

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

[Mike Fogleman]

With Conditional Formatting of the cells in columns 3 & 4, use Formula Is,
and this formula:

=AND(NOT(ISBLANK($E1)), NOT(ISBLANK($F1)))

Set the format to Font colour Red.

Mike F
"amrezzat" <amrezzat.1yswin_1132499402.455@excelforum-nospam.com> wrote in
message news:amrezzat.1yswin_1132499402.455@excelforum-nospam.com...
>
> 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=486656
>

[JE McGimpsey]

One way:

Select the third and fourth column (say, C:D, with C1 active). Choose
Format/Conditional Formatting:

CF1: Formula is =COUNTA(E1:F1)<2
Format1: <patterns>/<red>

In article <amrezzat.1yswin_1132499402.455@excelforum-nospam.com>,
amrezzat <amrezzat.1yswin_1132499402.455@excelforum-nospam.com> wrote:

> 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