Sep 14 2022 02:26 AM
If i put an 'X' in 'column 2' i would like columns 8 & 9 to turn orange. is that possible?
If i put an 'R' in 'Column 1' i would like columns 6&7 to turn yellow
Could anyone guide me please?
Open/RTC/ Closed | TSC Pegged | Skeen Check | Estimate start date | Operation | Response Type | Damage Number | Finance Number | Suburb | Road |
x | Veg/ Clear | IRW | DM01411 | A6522.1505 | Banora Point | Barneys Point Road | |||
R | Veg/ Clear | IRW | DM00059 | A5876.5664 | Bilambil | Bilambil Road |
Sep 14 2022 02:37 AM
This required 2 rules for conditional formatting as shown in the screenshot. Make sure that the "applies to" range and the rule for conditional formatting start in the same row. In the example both start in row 2.
Sep 14 2022 04:19 AM
Thanks for that
i still dont understand @OliverScheurich
In the conditional formatting where do i go please?
Sep 14 2022 04:34 AM
Select the range (the "applies to" range) you want to format with the mouse e.g. =$H$2:$I$24
Then go to:
Conditional formatting -> New rule
Use a formula to determine which cells to format
Format values where this formula is true.
Enter your formula (rule) for conditional formatting and choose the format you want to apply. Then click ok 2 times.
Sep 14 2022 05:19 AM
Sep 14 2022 06:09 AM
Thank you. It works when you remove the $ sign for the rows:
=$B2="c"
=$B2="r"
=$C2="x"
You can see how it works in the example below.