Register
Log In
Unanswered
Home
June 24, 2016
Offline
Hi there,
I am sure this can be done just not sure how to do it.
I am trying to create a spreadsheet that contains data and the last cell will require a specific response.
If that response is a certain response I want to turn the whole row containing data a particular colour.
Not sure if it is a formula but I can't locate it in Conditional Formatting.
Thank you in advance for assisting.
Adrian
Dashboards
Power BI
Power Query
April 21, 2015
Offline
Hi Adrian, maybe there is something also here on the MOTH site, but you can have a look at the friends of Exceljet. There are more video's there with about the same issue. I think this one gives the answer to your question: https://exceljet.net/formula/highlight-entire-rows
Good luck!
Most Users Ever Online: 57
Currently Online: Mark Lund, Rudi, Max Neumann
17 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Ajay Mukhi
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Janel Oz
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
