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 December 27, 2022 - Jun 11, 2019 at 12:03 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 11, 2019 at 12:03 PM
Related:
- Excel if cell is coloured then
- Excel mod apk for pc - Download - Spreadsheets
- If a cell has text then return value ✓ - Excel Forum
- Dash becomes date on excel ✓ - Office Software Forum
- Kernel for excel repair - Download - Backup and recovery
- Based on the cell values in cells b77 ✓ - Excel Forum
4 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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.