Hi, Please help with Conditional Formatting

Closed

gph - Oct 2, 2010 at 02:52 AM
Vince.$tone12 Posts 77 Registration date Saturday October 2, 2010 Status Member Last seen October 31, 2010 - Oct 2, 2010 at 09:23 AM

Hello,

I'm trying to figure out how I can add fill in a color in a cell depending on the outcome of this IF formula: =IF(C4>F4,C4-F4,F4-C4). I want to code it so that if C4-F4 than cell gets colored Green, and if F4 - C4 then I cell gets colored Red.

Help is very much appreciated. Thanks

Hi, Please help with Conditional Formatting
How to clear formatting in excel - Guide
Excel conditional formatting if another cell contains specific text - Excel Forum
Excel formula to change cell color without conditional formatting - Excel Forum
To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
Phone formatting software for pc - Download - File management

1 response

Answer 1 / 1

Vince.$tone12 Posts 77 Registration date Saturday October 2, 2010 Status Member Last seen October 31, 2010 5
Oct 2, 2010 at 09:23 AM

I in fact got to the FAQ section of Kioskea and found different articles about Conditional Formatting. I believe that the first one should be of great help to solve the difficulty that you are experiencing. Hopes it work correctly.

http://ccm.net/faq/956-colouring-cells-on-conditions

https://ccm.net/faq/6369-excel-conditional-formatting-for-an-entire-row

http://ccm.net/faq/5843-conditional-formatting-apply-on-more-cells

http://ccm.net/faq/5769-conditional-formatting-apply-on-more-cells

Kind regards.

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Highlight cell if another cell contains any text

one cell will turn green when the two other cells match

Conditional formating - apply on more cells

Similar discussions

Subscribe To Our Newsletter!