Conditional formatting
Hi, i need a formula to add in conditional formatting, that will change the
color of a cell if a certain condition is met. I have a table with datas. I need to change the patter color of the rows (rangeA:G) if G is emty. I need to change the color only if the above and below cells are not empty Ex: D 1 john 2 john 3 4 john i need the empty row (A:G) to be blue Can this be done? Thanks! |
All times are GMT +1. The time now is 10:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com