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.

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. *

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