Formula for conditional format to color cells
Closed
kipp2019
Posts
8
Registration date
Tuesday May 14, 2019
Status
Member
Last seen
June 6, 2019
-
Updated on May 16, 2019 at 11:51 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jun 11, 2019 at 12:03 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jun 11, 2019 at 12:03 PM
Related:
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do?
- Notepad++ change background color - Guide
- Excel formula to change cell color without conditional formatting - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- How to change crosshair color csgo - Guide
- Rj45 color code - Guide
4 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
May 16, 2019 at 11:40 AM
May 16, 2019 at 11:40 AM
Hi Kipp,
Give the following formula in conditional format a try:
=AND($A$1<>"",$A2="")
Applied range will be:
=$A$2:$A$15
Best regards,
Trowa
Give the following formula in conditional format a try:
=AND($A$1<>"",$A2="")
Applied range will be:
=$A$2:$A$15
Best regards,
Trowa
May 16, 2019 at 04:13 PM
now I want to delete out the text w/in cell a1. in doing so, I want cells a2-a15 to clear themselves all at once leaving a blank red cell.
can you do that TrowaD? please and thank you.