Hi, Please help with Conditional Formatting

Closed
Report
-
Posts
76
Registration date
Saturday October 2, 2010
Status
Member
Last seen
October 31, 2010
-
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

1 reply

Posts
76
Registration date
Saturday October 2, 2010
Status
Member
Last seen
October 31, 2010
5
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.