Set 18 Practical Question

⭐ Q18 – Billing Table + Conditional Formatting

Example Code (Read Only):


πŸ“Œ Program: Writer
βœ” Steps:
β€’	Columns: Item | Price | Qty | Total
β€’	Total formula β†’ =<B2>*<C2>
β€’	Apply Conditional formatting:
o	Select β€œTotal” column
o	Format β†’ Conditional β†’ Condition
o	Condition: Greater than 1000 β†’ Color Red

M1 - MS Office Practical

Upload Your Practical File