Previous Topic Next Topic

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

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

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Conditional Format Cells Based on Another Cell and Own Cell
Elaine -
x -

1 response
Conditional formatting based text in another cell
y88y -
y88y -

2 responses
Conditional formatting several cells risk register
oyvinols -
fdibbins -

1 response