formatting

Occasional Contributor

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/ ClosedTSC PeggedSkeen CheckEstimate start dateOperationResponse TypeDamage NumberFinance NumberSuburbRoad
 x  Veg/ ClearIRWDM01411A6522.1505Banora PointBarneys Point Road
R   Veg/ ClearIRWDM00059A5876.5664BilambilBilambil Road
9 Replies

@sketa 

conditional formatting.JPG

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.

 

Thanks for that 

i still dont understand @Quadruple_Pawn 

In the conditional formatting where do i go please?

@sketa 

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

cf new rule.JPG

Use a formula to determine which cells to format

use formula.JPG

Format values where this formula is true.

format values.JPG

Enter your formula (rule) for conditional formatting and choose the format you want to apply. Then click ok 2 times.

Thanks you for your help
when i put an 'x' in the first row it highlights all rows.

any suggestions from here?

@sketa 

Can you attach your file without sensitive data?

i can but i dont know how?

@sketa 

sketa_0-1663158904516.png

 

sketa_1-1663158924171.png

 

@sketa 

$ sign for row.JPG

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.

conditional format.JPG