Register
Log In
Unanswered
Home
New Member
June 21, 2013
Offline
Hi
Is there anyway to highlight table in one go by highlight row's number is bigger than column E? I could individually select each row to do conditional formatting, but I would like to select the whole table range to highlight in one go. Hopefully made sense.
Thanks
Jian
| A1 | A2 | A3 | A4 | Criteria > Column E |
| €38.61 | €14.11 | €6.81 | €49.63 | 11 |
| €19.60 | €7.35 | €8.86 | €64.64 | 6 |
| €17.10 | €3.96 | €9.97 | €69.23 | 44 |
| €24.80 | €7.37 | €10.67 | €77.77 | 11 |
| €27.06 | €7.11 | €17.20 | €125.00 | 22 |
| €38.60 | €14.10 | €42.56 | €309.94 | 55 |
| €41.46 | €15.81 | €45.75 | €333.69 | 4 |
| €34.84 | €36.71 | €32.34 | €13.42 | 1 |
| €26.56 | €27.99 | €22.83 | €13.81 | 2 |
| €34.84 | €36.71 | €32.34 | €19.39 | 10 |
| €19.27 | €20.31 | €15.61 | €20.60 | 12 |
| €21.54 | €22.70 | €13.98 | €22.50 | 25 |
| €27.56 | €29.04 | €23.41 | €23.45 | 11 |
| €26.56 | €27.99 | €22.83 | €26.39 | 20 |
| €25.37 | €26.73 | €18.18 | €26.39 | 21 |
| €38.99 | €41.09 | €34.24 | €32.36 | 30 |
See Answer
Dashboards
June 25, 2016
Offline
Hi Jian Guan
Do the following
1) Select then range A2:D17
2) Select Conditional Formatting - Highlight Cells Rules - Greater Than
3) In the selection box click on cell E2
4) Then press the F4 function key 2 times till the formula changes to =$E2
5) Press ENTER and then click OK
Hope this helps
Answers Post
New Member
June 21, 2013
Offline
Hi SunnyKow,
Great help. Could I ask when to use by press F4 once?
Thanks
Jian
Dashboards
Power BI
Power Query
April 21, 2015
Offline
After coming in editing a cell you can type in the reference you want in different ways to make the reference relative or absolute.
You can choose (depending on what you need) in: =E2, =$E2, =E$2 or =$E$2.
This is a lot of typework everytime.
With the F4 key you can toggle between these options when you are in 'editing mode'. So that's the point of the number 4) of Sunny.
Most Users Ever Online: 57
Currently Online: azri adrin, Mark Lund, Rudi
20 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
