Bobjg
New Member
- Joined
- Dec 11, 2019
- Messages
- 24
- Office Version
- 365
- Platform
- Windows
Hello,
I am having issues with conditional formatting. I have setup a few rules that work but others don't? See images of worksheet and rules below. I Just want column H to return formatting based on this IF statement: =IF(G12<=0, "Expired", IF(G12<=60, "Red Flag", IF(G12>90, "Green Flag ", ""))). Pretty straight forward. I have changed the cell formatting to text, general etc.
Any assistance would be great.
Any assistance would be most appreciated
Thanks - Bob
I am having issues with conditional formatting. I have setup a few rules that work but others don't? See images of worksheet and rules below. I Just want column H to return formatting based on this IF statement: =IF(G12<=0, "Expired", IF(G12<=60, "Red Flag", IF(G12>90, "Green Flag ", ""))). Pretty straight forward. I have changed the cell formatting to text, general etc.
Any assistance would be great.
Any assistance would be most appreciated
Thanks - Bob