Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
A user of Web Applications asked "How should I fix the formula?" with reference to: =IF($K4<2,$K4) applied as a Conditional Formatting [CF] formula to J4:J8, where the desired (green fill) f...
#5: Post edited
by
Wicket
·
2023-06-20T17:57:19Z (10 months ago)
edited tags
Conditionally format a pair of columns
A user of Web Applications [asked](https://webapps.stackexchange.com/questions/139573/conditional-formatting-custom-formula) "*How should I fix the formula?*" with reference to:
=IF($K4<2,$K4)
applied as a Conditional Formatting [CF] formula to J4:J8, where the desired (green fill) format was to apply to values under `2` in K4:K8. I have modified the requirement to extend the formatting to 'K' as well as 'J', so the *Applies to* range to J4:K8.
These formulae in the image below were working as expected:
How can the desired outcome be achieved?
#4: Post undeleted
by
Alexei
·
2021-05-26T18:06:46Z (almost 3 years ago)
#3: Post deleted
by
pnuts
·
2020-12-07T15:37:11Z (over 3 years ago)
#2: Post edited
by
pnuts
·
2020-10-02T09:14:11Z (over 3 years ago)
- A user of Web Applications [asked](https://webapps.stackexchange.com/questions/139573/conditional-formatting-custom-formula) "*How should I fix the formula?*" with reference to:
- =IF($K4<2,$K4)
applied as a Conditional Formatting [CF] formula to J4:K8, where the desired (green fill) format was to apply to values under `2` in K4:K8.- These formulae in the image below were working as expected:
- 
- How can the desired outcome be achieved?
- A user of Web Applications [asked](https://webapps.stackexchange.com/questions/139573/conditional-formatting-custom-formula) "*How should I fix the formula?*" with reference to:
- =IF($K4<2,$K4)
- applied as a Conditional Formatting [CF] formula to J4:J8, where the desired (green fill) format was to apply to values under `2` in K4:K8. I have modified the requirement to extend the formatting to 'K' as well as 'J', so the *Applies to* range to J4:K8.
- These formulae in the image below were working as expected:
- 
- How can the desired outcome be achieved?
#1: Initial revision
by
pnuts
·
2020-10-02T00:39:57Z (over 3 years ago)
Conditionally format a pair of columns
A user of Web Applications [asked](https://webapps.stackexchange.com/questions/139573/conditional-formatting-custom-formula) "*How should I fix the formula?*" with reference to:
=IF($K4<2,$K4)
applied as a Conditional Formatting [CF] formula to J4:K8, where the desired (green fill) format was to apply to values under `2` in K4:K8.
These formulae in the image below were working as expected:
How can the desired outcome be achieved?