How do I check the font color in a cell?

**smr108** · 10-07-2011, 01:16 AM

I would like to be able to check a cell for the color of the font in it. For example I have a cell with the number $1,000 and it is blue. How do I detect it is blue vs black or some other color?

**inayat** · 10-07-2011, 01:22 AM

Hi... Welcome to the forum...

I am not sure I follow your question. If the font color is blue then it is blue... Do you want to change the color... or is it so that the color depends on the value of the cell...

**royUK** · 10-07-2011, 01:26 AM

Is the cell coloured using Conditionl formatting?

**smr108** · 10-07-2011, 08:58 PM

Originally Posted by royUK

Is the cell coloured using Conditionl formatting?

Thank you for the welcome! The cell is not formatted using conditional formatting. I just typed in the number and turned it blue. Now I want to check that it is blue and if true perform an action in an if function for example. Does that help?

**alansidman** · 10-07-2011, 11:55 PM

This video should help you to determine font colors.

http://www.datapigtechnologies.com/f...rtonColor.html

Alan

**smr108** · 10-08-2011, 01:35 AM

Bingo! The video showed me exactly what I needed!!! Thank you!

**DonkeyOte** · 10-08-2011, 02:49 AM

Bear in mind altering the font colour manually is a non-volatile action and thus does not trigger any events ... you must manually invoke a recalculation to remove risk of incorrect results at all times.

As a general rule of thumb (in Excel) never use manual formatting as means of differentiation for dependent calculations.