Mar 09 2022 05:18 PM
Is there a way changing the text or cell fill, in response to the test; if x<y then cell colour Green, if this is not the case then text or cell colour Red.
I am not an Excel expert!
Mar 09 2022 06:18 PM
@Snafu_2505
yes,
use conditional formatting to do so
https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60...
go to home>> under style tab>> conditional formatting>> select new rule
formatting cell will make colors you need