DarkChaosDS
New Member
- Joined
- May 3, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello, I am using conditional formatting to highlight certain cells yellow. It seems although the cells appear yellow through conditional formatting, excel is not recognizing them as actually being highlighted yellow. Is there anyway to convert conditional formatting to an actual highlight so excel recognizes the cells as actually being yellow. I ask this as I have a Macro formula added to recognize a yellow highlight to sum only yellow cells, however it does not work on the yellow conditionally formatted cells.
Thanks
Thanks