Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have to conditionally apply a style to a cell in Excel. I know how to do it in LibreOffice calc:

=B4+STYLE(IF(ABS(B4-B3)/B4>0.07,"Red","Default"))               

How do I do it in Excel?

Excell recognizes ABS and IF -- but not STYLE. What is the analogue for STYLE in Excel?

share|improve this question

1 Answer 1

You can't do that within the formula in Excel, I assume the worksheet formula will be just

=B4

then you can use "conditional formatting" from Home tab. Use the option "use a formula to determine which cells to format" then apply a similar formula to the above, i.e.

=ABS(B4-B3)/B4>0.07

select red fill or font > OK

You can apply to a range of cells if you wish, just use the formula that applies to the top left cell of range.

My instructions assume you are using Excel 2007 or later....

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.