If I update chq. no. & Chq. dt. column the row should color.
Kindly give me solutionI have 9 Column worksheet 1) Sr. No. , 2) Name, 3) Inv. No. 4)Inv. Dt., 5)Inv. Amt, 6)TDS Rate,7)TDS Amt, 8) Chq. No.,9)Chq. Dt.
If I update chq. no. & Chq. dt. column the row should color.
Kindly give me solution
You can't post conmments that contain an email address.
Use conditional formatting for the coloumn of student use Option " Formula Is" - In this write cell address of Marks e.g.c5
Then write =$c5>80 then click format and format the pattern
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
I have 9 Column worksheet 1) Sr. No. , 2) Name, 3) Inv. No. 4)Inv. Dt., 5)Inv. Amt, 6)TDS Rate,7)TDS Amt, 8) Chq. No.,9)Chq. Dt.
If I update chq. no. & Chq. dt. column the row should color.
Kindly give me solution
×