Change cell colour based on values in other columns.
Closed
dcundill
Posts
1
Registration date
Wednesday 17 June 2015
Status
Member
Last seen
17 June 2015
-
17 Jun 2015 à 10:41
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 17 Jun 2015 à 13:45
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 17 Jun 2015 à 13:45
Related:
- Change cell colour based on values in other columns.
- How to change text colour html - Guide
- How to change language in idm - Guide
- Change lg tv name - Guide
- Change computer name - Guide
- How to change language in mx player ✓ - Audio Forum
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
17 Jun 2015 à 13:45
17 Jun 2015 à 13:45
dcundill, Good morning.
Try to use:
1) Apply Conditional Formatting to C1 cell using formula:
Rule 1:=AND(A1=3,B1=1)
Choose RED colour as fill
2) Apply Conditional Formatting to C2 cell using formula:
Rule 1: =AND(A2=2,B2=2)
Choose YELLOW colour as fill
Rule 2:=AND(A2=2,B2=3)
Choose RED colour as fill
3) Apply Conditional Formatting to C3 cell using formula:
Rule 1: =AND(A3=1,B3=2)
Choose GREEN colour as fill
Rule 2:=AND(A3=1,B3=3)
Choose YELLOW colour as fill
Please, tell us if it worked for you.
Is it what you want?
I hope it helps.
Try to use:
1) Apply Conditional Formatting to C1 cell using formula:
Rule 1:=AND(A1=3,B1=1)
Choose RED colour as fill
2) Apply Conditional Formatting to C2 cell using formula:
Rule 1: =AND(A2=2,B2=2)
Choose YELLOW colour as fill
Rule 2:=AND(A2=2,B2=3)
Choose RED colour as fill
3) Apply Conditional Formatting to C3 cell using formula:
Rule 1: =AND(A3=1,B3=2)
Choose GREEN colour as fill
Rule 2:=AND(A3=1,B3=3)
Choose YELLOW colour as fill
Please, tell us if it worked for you.
Is it what you want?
I hope it helps.