My template involves three cells, but only one cell needs help (the 3rd).
The first cell will equal either $0 or something greater. The second cell will be greater than $0 or be blank. The third cell should equal the value in the second cell only if the first cell is not equal to $0. If the value of the first cell is equal to $0, then the third cell should equal $0.
The first cell is a simple formula based on other non-related inputs from the user. The font is always red.
The second cell is a simple user input. The font is always blue here, but the user may manually fill the cell with yellow color (based on whether the value is actual or estimated).
The third cell should be in bold green font if it’s value is greater than $0, and red font (not bold) if it’s value is equal to $0. Also, this cell should be filled with yellow color only if the second cell is filled with yellow AND if the first cell value is greater than $0.
I’m thinking the solution involves a combination of these functions; which is beyond my EXCEL skill level. 1) IF/THEN formula 2) Conditional Formatting 3) VBA code
What should I do to the third cell in order to get all that I want automatically (without the user needing to touch the third cell)?
Thanks in advance!