I need to put conditional formatting into an Excel sheet. When one cell has data entered, the entire row must have the font color changed. Any suggestions?
vbforum
0
Newbie Poster
FranAust
commented:
This will definitely work, maybe someone knows another way?
+0
Recommended Answers
Jump to PostMay want to edit your tags as the question/topic seems to be about Excel and not VBA or VB.NET.
So I went to Google this and put in this question:
How do I apply conditional formatting to an entire row based on one cell?
The answer came back …
Jump to PostThis works, but you have to specify each cell in the row.
Noted elsewhere:
Conditional Formatting is the same as adding one or more formulas to each cell in which you use it
All 7 Replies
rproffitt
2,580
"Nothing to see here."
Moderator
vbforum
0
Newbie Poster
rproffitt
2,580
"Nothing to see here."
Moderator
vbforum
0
Newbie Poster
vbforum
0
Newbie Poster
rproffitt
2,580
"Nothing to see here."
Moderator
rproffitt
2,580
"Nothing to see here."
Moderator
FranAust
commented:
This will definitely work, maybe someone knows another way?
+0
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.