Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have some openoffice calc sheets where some rows are maked with the font color red. All other rows are in the default font color.

Can I use the font color of a cell within a formula to react to this or is this impossible?

Example: Assuming I have column A with red and black cells, how would I create a column B that has "1" if A is red and "0" if A is black?

share|improve this question
Yes, it's possible. You might want to start here – Raystafarian Jul 25 '13 at 9:32
This points to the STYLE command that lets me set the color. I'm looking for something that lets me read the color to use in formulas. I'm updating the question to make this clearer... – 576i Jul 25 '13 at 12:53
Use the style function to pull the color from the adjacent cell. Like an if(T(style( type function or similar – Raystafarian Jul 25 '13 at 13:10
AFAIK this doesn't work. STYLE() returns 0 independet of the the current style. Additionally, the documentation states explcitely: "There is no direct way to determine (in a formula) what formatting has been applied to a cell." – tohuwawohu Aug 10 '13 at 11:03

You must log in to answer this question.

Browse other questions tagged .