I am looking for a conditional format formula to highlight a cell depending on the following criteria:
If F28 is >3 or G28 is >3 or F28+G28>6 and I would be much obliged if anyone can help.
Many thanks for looking.
I am looking for a conditional format formula to highlight a cell depending on the following criteria:
If F28 is >3 or G28 is >3 or F28+G28>6 and I would be much obliged if anyone can help.
Many thanks for looking.
Re: Help on a Conditional Format Formula
Formula would be:
=OR($F$28>3,$G$28>3,$F$28+$F$28>6)
I'm assuming you need absolute references, but if not, remove the dollar signs as appropriate.
Don’t have an account yet? Register yourself now and be a part of our community!