The use of AI tools (e.g. chatGPT, BARD, GPT4 etc) to create forum answers is not permitted. If a user is believed to have used such tools to provide a forum answer, sanctions may be imposed.
For the best help attach a sample workbook to your post
Attention - ExcelForum Rules have been updated as of August 2023. These rules apply to everyone for the benefit of all, please take a moment now to read them so you will have no issues in complying with them. Please read them here .
New Notice for experts and gurus:
Recently, it has become clear that some members (especially newer members) have been confused by "mixed messages" coming from non-Moderators. They are unclear how to react to such requests. Accordingly, we are now asking all members NOT to attempt to moderate threads. From now on, that will be done by forum Moderators only.We continue to encourage the reporting of posts/threads where cross-posting has not been declared, where measures to bypass sheet security are requested, or where abusive language is being used. Generally speaking, it it NOT necessary to report poor titles, spam, lack of code tags, etc, as these are easily spotted by forum Moderators.From now on, those posts made by non-Mods that are attempting to carry out Moderation activities will be deleted.

+ Reply to Thread

Results 1 to 5 of 5

Conditional Formatting with blank cells

LinkBack
- LinkBack URL
- About LinkBacks
Thread Tools
- Show Printable Version
- Subscribe to this Thread…
Rate This Thread
- Current Rating
- ‎ Excellent
- ‎ Good
- ‎ Average
- ‎ Bad
- ‎ Terrible
Display
- Linear Mode
- Switch to Hybrid Mode
- Switch to Threaded Mode

03-06-2020, 03:51 PM #1
andrewc

View Profile

View Forum Posts
Forum Contributor

Join Date

02-08-2005

MS-Off Ver

Microsoft 365

Posts

839
Conditional Formatting with blank cells
Hi,

I would like to conditionally format $A$2:$D$20 following the rule in the attached sample workbook.

Can someone please tell me how to adjust this so that rows without an entry in column A aren't conditionally formatted?

Thanks

Attached Files

Cond Formatting Alt Rows.xlsx‎ (11.4 KB, 5 views) Download
Last edited by andrewc; 03-06-2020 at 04:27 PM.
Register To Reply
03-06-2020, 03:52 PM #2
Fluff13

View Profile

View Forum Posts
Forum Guru

Join Date

09-10-2017

Location

Chippenham, England

MS-Off Ver

365

Posts

15,769
Re: Conditional Formatting with blank cells

How about
=AND(A2<>"",MOD(ROW(),2))
Register To Reply
03-06-2020, 03:55 PM #3
mehmetcik

View Profile

View Forum Posts
Forum Expert

Join Date

12-14-2012

Location

London England

MS-Off Ver

MS 365 Office Suite.

Posts

8,448
Re: Conditional Formatting with blank cells
=and(A1<>"",MOD(ROW(),2))

Attached Files

Cond Formatting Alt Rows.xlsx‎ (17.9 KB, 3 views) Download
My General Rules if you want my help. Not aimed at any person in particular:

1. Please Make Requests not demands, none of us get paid here.

2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Register To Reply
03-06-2020, 04:27 PM #4
andrewc

View Profile

View Forum Posts
Forum Contributor

Join Date

02-08-2005

MS-Off Ver

Microsoft 365

Posts

839
Re: Conditional Formatting with blank cells

Thanks very much!
Register To Reply
03-06-2020, 04:33 PM #5
Fluff13

View Profile

View Forum Posts
Forum Guru

Join Date

09-10-2017

Location

Chippenham, England

MS-Off Ver

365

Posts

15,769
Re: Conditional Formatting with blank cells

You're welcome & thanks for the feedback
Register To Reply