Conditional Format for font color using font color
 

Is there a way for setting up a conditional format using another cell's font
color. I'm importing data into a spreadsheet that has font color formatting
and want to format other cells based on the font color.

Conditional Format for font color using font color
 

You can't do that with standard conditional formatting.

Pete

On Aug 27, 11:09*pm, Jim wrote:
Is there a way for setting up a conditional format using another cell's font
color. *I'm importing data into a spreadsheet that has font color formatting
and want to format other cells based on the font color. *

Conditional Format for font color using font color
 

On Aug 28, 12:47 am, Pete_UK wrote:
You can't do that with standard conditional formatting.

Pete

On Aug 27, 11:09 pm, Jim wrote:

Is there a way for setting up a conditional format using another cell's font
color. I'm importing data into a spreadsheet that has font color formatting
and want to format other cells based on the font color.

Hi,
have a look at the advanced search "colour" on ozgrid.com (VBA area):

http://www.ozgrid.com/search/ozgrid-...sa=Search#1068

(be carefull with potential linebreaks in this URL)

Hope that helps.
Michael