DennisYoung
New Member
- Joined
- Jun 27, 2022
- Messages
- 15
- Office Version
- 2021
- 2016
- Platform
- Windows
This is happening when there are only 2 records returned, if the refresh returns more records, then the table header color is correct (Blue)
My format values starting off are =AND(E10="",F10="") and the Applies to is =$E$10 and the conditional formatting it backround color Yellow (First Image)
But when I run it and there are only 2 records to return the format value changes to =AND(E9="",F9="") and the Applies to is =$E$9:$E$11 (Second Image)
When more than 2 records are returned the format value stays at =AND(E10="",F10="") and the Applies to is =$E$10:$E$31 (Third Image) and everything is how it should be
Has anyone seen this before when using conditional formatting or know a way to make it start at row 10 and not change row 9 (Table header row)
The goal is to change just color the cells that meet the criteria and not the header rows
My format values starting off are =AND(E10="",F10="") and the Applies to is =$E$10 and the conditional formatting it backround color Yellow (First Image)
But when I run it and there are only 2 records to return the format value changes to =AND(E9="",F9="") and the Applies to is =$E$9:$E$11 (Second Image)
When more than 2 records are returned the format value stays at =AND(E10="",F10="") and the Applies to is =$E$10:$E$31 (Third Image) and everything is how it should be
Has anyone seen this before when using conditional formatting or know a way to make it start at row 10 and not change row 9 (Table header row)
The goal is to change just color the cells that meet the criteria and not the header rows