ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional formatting (https://www.excelbanter.com/excel-discussion-misc-queries/258854-conditional-formatting.html)

puiuluipui

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