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
hi,
need a formula or conditional format:
if cell a1 has text, then apply the color RED to cells underneath say a2-a15.
then, once numbers are inserted in the cells a2, a3, a4, etc, those cells keep the numbers but turn the cells back to no fill or white.
Related:

4 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
0
kipp2019 Posts 8 Registration date Tuesday May 14, 2019 Status Member Last seen June 6, 2019
May 16, 2019 at 04:13 PM
amazing. absolutely unbelievably amazing. great job. spot on 100% correct. thank you SO much. now, the reward for good work is more work.

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.
0