I am creating a google spreadsheet and stuck in one point ....
This related For conditional formatting.
Actually, I want to create conditional formatting in custom formula, which will give BG color in the row based on the job status in the cell.
- Progress
= bg green
-
= bg blue
- for review
= Bg Gray
I have 2 & amp; 3 using the following formula:
Done:
conditional formatting> Custom Formula & gt; `= Indirect (" F "and row ()) = 100` Range> `C2: C1006, D2: E13, F2: F1006, G14: G16, D17: E1006`
is for review by = 99
I hope the questions are clear, thanks.
=> 0 and <99>
There is a need to progress.
No comments:
Post a Comment