Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
change font color of cell based on critera
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" 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=486656 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
change font color of cell based on critera
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change font color based on a value | Excel Worksheet Functions | |||
how do i change row font color based on cell value in that row | Excel Worksheet Functions | |||
change font color of cell based on critera | Excel Worksheet Functions | |||
Change Font Color in cell Based on another cell value | Excel Programming | |||
Font to change color automatically based on value in cell. | Excel Programming |